devxlogo

Informix Version 7 SQL Query

Informix Version 7 SQL Query

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.

devx-admin

Share the Post: