Your host:
Stephen Chapman

Select Top Six

Question: In my data base there are 1000 records. I want to access only the top six records depending on their salary. How to do this?
Soni

Answer:Select all of the records ordered by salary in descending order.

SELECT * FROM mytable ORDER BY salary DESC;

Then just read the first 6 records retrieved.