Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Top 2 choices ?
- Thread starter Noah114
- Start date
Have a look at the TOP keyword in SQL - also available from the query properties.
Note that you cannot combine TOP with DISTINCTROW - in that case you need to create one query with distinctrow or groupings, and base another query on that one to select the top 2.
Note that you cannot combine TOP with DISTINCTROW - in that case you need to create one query with distinctrow or groupings, and base another query on that one to select the top 2.
- Status
Similar threads
- Locked
- Question
- Locked
- Question