By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

Display Top 5 record results from a query.

P: 72
Hello,
I have searched and have found some related data, but I am not understand "how to".

I have a query where I pulled a record set from a table. The fields are "hull #" and "wo #" I.e.

Hull: 184 Wo# 12345.

The results are sorted by WO# in descending order. I need criteria so the query only returns the top 5 records.

Thxs.
Mar 19 '07 #1
Share this Question
Share on Google+
2 Replies


P: 72
Found it, sorry.
Mar 19 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Found it, sorry.
No Problem.

For anyone else looking here

Expand|Select|Wrap|Line Numbers
  1. SELECT TOP 5 ....
Will retrieve the top 5 records in an ordered set.

Mary
Mar 22 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.