Get User Details by Email from Table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

, +

I have a Article table...The user post the articles in different category by their Email id..
i need to take a following information from that table...

Unique Emailid and how many post(count of total post)done through that emailid, category, No of posts in each category.....

I need to select all unique emailid with above informations....

Fields in ArticleTB :
Title, description, Categoryid, EmailId, PostedDate

Posted 18-Jul-14 17:43pm

SnvMohan

Updated 18-Jul-14 17:44pm

v2

Add a Solution

Comments

Dilan Shaminda 19-Jul-14 0:20am

have you tried anything? Or any error in your query?

SnvMohan 19-Jul-14 2:21am

I tried this for getting unique Email but cant get other information as i needed...

select Distinct Email from ArticleTB

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nilesh sawardekar · Answer 1 · 2014-07-18T20:11:00

As per your requirement, if you want all this data in single query then thats not possible. Reason behind this is,
You first of all need unique email id and lastly you said that you want 'No of posts in each category', that nothing but your finding unique category. Logically and naturally two unique things can not be added to same row. Even that possible if there single category or single email id.

please let me know if you understand this or any other help you need.

SnvMohan · Answer 2 · 2014-08-04T20:46:00

Solution 2

SELECT Title, EmailId,Count(EmailId) as totalads
FROM dbo.ArticleTB
where PostedDate > DATEADD(dd, -2, GETDATE()) AND PostedOn < DATEADD(dd, -1, GETDATE())
GROUP BY EmailId,Title;

Posted 4-Aug-14 20:46pm