How can I limit query rows in cases with 'ties'?

[married2themachine]

I'm trying to limit query output rows to 10...but when my sort column has records with the same value (ties), all of them display (over and above the Top 10 that I have set).

I have tried 'select distinct top 10 ...' but since the other fields are different, each record is distinct.

Will I have to drop the data into a temporary table with row limits?

 

[jebry]

Hi!

Choose a second field to sort by and as long as that field is different after the 10th record your query will limit it to ten.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst