Results 1 to 2 of 2

Thread: SQL 'SELECT DISTINCT' with Count ?

  1. #1
    aibon Guest

    Default SQL 'SELECT DISTINCT' with Count ?

    hi<BR><BR>i have to make a statistic chart and im asking me if it isnt possible to get all distinct Values from a colum with their counts?<BR><BR>like &#039SELECT DISTINCT Age FROM Answers COUNT/COMPUTE BY???&#039<BR><BR>is there something?<BR><BR><BR>

  2. #2
    sqlphreak Guest

    Default RE: SQL 'SELECT DISTINCT' with Count ?

    If you want both the value and its count:<BR><BR>SELECT age, count(age) FROM Answers GROUP BY age

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts