TOP 5 QUERY

[Tim H]

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.

 

[Jason Lepack]

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.

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

 

[Tim H]

THANK YOU!

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