Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jan 3, 2000

Double-Count in a SQL Query

Question:
I want to create two count-variables in one SQL query based on GROUP BY signum_chef. Is that possible? I've tried something like this:
 
SELECT DISTINCT 
signum_chef, 
  Antal=(SELECT COUNT (*)), 
  Antal1=(SELECT COUNT (*) 
  FROM anstallda 
  WHERE anstnr IN (" & sEmployeeID & ")) 
FROM anstallda 
GROUP BY signum_chef 

Answer:
Sorry, but I'm not 100 percent clear on your intent. I'd like to offer the following. I think it is redundant to use DISTINCT with GROUP BY, because GROUP BY collapses the result around the members of the projection, so what is DISTINCT going to do?

Also, I don't think it will work to have Antal and Antal1 in the select list without them appearing in the GROUP BY expression.

Is IN what you intended? If you are making a comparison to some parameter, and it is a key, wouldn't an equality match work better?

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date