Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language:
Expertise: Beginner
May 23, 2000

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 from
sales_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 Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date