Hopefully simple transact question

[austinmoran]

I have a one column table with 65,000 records comprised of office numbers. In some cases an office number may be listed thirty or forty times, while in other cases an office number may only be listed once or twice. I would like to be able to do a count on DISTINCT office numbers and then display only the TOP 100 office numbers. I've tried several different things without success. Can someone point this novice in the correct direction please? THANKS IN ADVANCE!!!!

 

[gmmastros]

Try these.

Select Distinct Top 100
       ColumnName
From   TableName
Order BY ColumnName

Select Count(Distinct ColumnName) 
From   TableName

Select ColumnName, Count(*) As TheCount
From   TableName
Group By ColumnName
Order By ColumnName

If you have any questions, please ask.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom