>I am trying to count on these records for a certain criteria though. For ex: I have a table with 41,000 records that contains serial numbers for products, and need to know the top 10 selling products for that day?? I know that top 10 will give me the top 10 but without a count on that serial number. I need to get it to count on those distinct serial numbers. Maybe you can not do this with a select statement Can You??
>
>Darren

Probably, you ask something else. If you want to get 10 top counters then you should do following:
select top 10 count(*) as counter,* from mytable group by ser_number order by 1 desc