How to use count and group by at the same select statement

by

This will do what you want (list of towns, with the number of users in each):

select town, count(town) 
from user
group by town

You can use most aggregate functions when using GROUP BY:

(COUNT, MAX, COUNT DISTINCT etc.)

Update (following change to question and comments)

You can declare a variable for the number of users and set it to the number of users then select with that.

DECLARE @numOfUsers INT
SET @numOfUsers = SELECT COUNT(*) FROM user

SELECT DISTINCT town, @numOfUsers
FROM user

More Related Contents:

  1. SQL query for finding records where count > 1
  2. SQL to Entity Framework Count Group-By
  3. Conditional SQL count
  4. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  5. Is there any difference between GROUP BY and DISTINCT
  6. Fast way to discover the row count of a table in PostgreSQL
  7. GROUP BY to combine/concat a column [duplicate]
  8. Select count(*) from multiple tables
  9. Ms Access Query: Concatenating Rows through a query
  10. count(*) vs count(column-name) – which is more correct? [duplicate]
  11. Group by month and year in MySQL
  12. SQL Group by & Max
  13. How to count instances of character in SQL Column
  14. Fastest way to determine if record exists
  15. SQL count(*) performance
  16. MySQL #1140 – Mixing of GROUP columns
  17. PostgreSQL Where count condition
  18. Count Returning blank instead of 0
  19. Huge performance difference when using GROUP BY vs DISTINCT
  20. sql group by only rows which are in sequence
  21. GROUP BY without aggregate function
  22. MySQL GROUP BY behavior
  23. SQL: How do you select only groups that do not contain a certain value?
  24. Get values from first and last row per group
  25. How to return a incremental group number per group in SQL
  26. Run a query with a LIMIT/OFFSET and also get the total number of rows
  27. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  28. Query for count of distinct values in a rolling date range
  29. How to group by a Calculated Field
  30. How to do a case sensitive GROUP BY?

Leave a Comment