LCE270 - Top-10 and Bottom-10 Query


To use the sort facilities to create two queries:

To achieve these objectives you will complete the following:

Top-10 query

Step 1. Build a query over the Employee file

Step 2. Limit the results to the first 10 records

Step 3. Sort the data (in descending order)

Step 4. Run the query

Step 5. Save the query definition

Bottom-10 query

Step 6. Sort the data (in ascending order)

Step 7. Run the query

Step 8. Close the Query and Result windows


Before You Begin

You may wish to review the following topic in this guide: