Question:
How do I find the top n records within a table for version 7? I have seen some similar SQL queries but cannot adapt them to version 7.
Answer:
SQL does not have a “top” type of function, meaning that you can’t write something like:
SELECT top 5 account_name, sales_amount fromsales_table
You can write a SQL statement like this:
SELECT account_name, sales_amount FROM
sales_table order by sales_amount DESC
Then you could put it in a cursor and just select the first five rows, but that would have to be done programmatically.