TOP 5 QUERY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to grab the top or 1st 5 records in a table? So, if I have a
table of salesperson, I want to sort by volume and grab the top X number of
records only.
 
Is there a way to grab the top or 1st 5 records in a table? So, if I have a
table of salesperson, I want to sort by volume and grab the top X number of
records only.
Click to expand...

Yup, just change the table and field names as appropriate.

SELECT TOP 5 *
FROM sales_person_table
ORDER BY sales_volume DESC

Cheers,
Jason Lepack
 
THANK YOU!

Jason Lepack said:
Yup, just change the table and field names as appropriate.

SELECT TOP 5 *
FROM sales_person_table
ORDER BY sales_volume DESC

Cheers,
Jason Lepack
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Top with aggregate function 1
return middle 90% 1
Access Queries 1
Update top x records 6
Want a counter for Access Query results 8
Selecting top 5 2
Top 5 Query Question 2
Randomize records then select TOP (x) 7

Back
Top