devxlogo

Double-Count in a SQL Query

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?

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist