How to select top 10 in Access query?

by 
select top 10 Name, Price
from MyTable
order by Price desc

Updated: @Fionnuala pointed out that:

“Access SQL selects matches, so it will select all items with the
same highest prices, even if this includes more than 10 records. The
work-around is to order by price and a unique field (column).”

So, if you have a unique product code column, add like so:

select top 10 Name, Price
from MyTable
order by Price desc, UniqueProductCode desc

More Related Contents:

  1. How do i add percentage an Access query?
  2. How does one decompile and recompile a database application?
  3. How do you use version control with Access development?
  4. What are the rules governing usage of parenthesis in VBA function calls?
  5. Autonumber value of last inserted row – MS Access / VBA
  6. Microsoft Access condense multiple lines in a table
  7. How to get random record from MS Access database
  8. Code to loop through all records in MS Access
  9. Syntax error in insert into statement – what’s the error?
  10. create form to add records in multiple tables
  11. Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb
  12. How do I force VBA/Access to require variables to be defined?
  13. Why is my query not updateable?
  14. Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths – Error 3050
  15. Is it possible to create a recursive query in Access?
  16. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  17. What is the equivalent of Select Case in Access SQL?
  18. How do I access the selected rows in Access?
  19. Access 2007 – Left Join to a query returns #Error instead of Null
  20. Pivot Query in MS Access
  21. insert query with sequential primary key
  22. How do I execute multiple SQL Statements in Access’ Query Editor?
  23. Transform multiple rows into columns with unique key
  24. how to show query results in a datasheet in the same form?
  25. Selecting 2 tables from 2 different databases (ACCESS)
  26. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  27. MS Access prepared statements
  28. Linked table ms access 2010 change connection string
  29. Create sequential ID value based on the year that a record is added
  30. How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?

Leave a Comment