select number of rows from query

quinnd6

In sql plus
How do I get the number of distinct rows of a certain value?

for example

select group_number from records group by group_number

How would I query for the total number of group_numbers in this query?

Tom Dunne

quinnd6 wrote:

In sql plus
How do I get the number of distinct rows of a certain value?


select group_number from records group by group_number

I'm not sure I am following you.

Are you looking to count the number of rows returned?

If so, use the COUNT() function:

select COUNT(group_number) from records

or, if you wanted distinct values for group_number:

select COUNT(DISTINCT(group_number) from records

seamus

select count(id), group_number from records group by group_number

koloughlin

If you want distinct ids then you could try

select group_number, count(distinct id) from records group by group_number

quinnd6

select count(distinct(group_number) from records
is what I was looking for.
Thanks