How to do SQL select top N ... in AS400

sql ibm-midrange
James Moore picture James Moore · May 17, 2010 · Viewed 75.3k times · Source

How do you perform a 

Select top N * from as400table

type query against an as400/db2 database

Answer

James Moore picture James Moore · May 17, 2010 
Select col1,col2
from 
as400table
where col1='filter'
order by col1
fetch first N row only

Remember to set an ORDER BY clause, because DB2 does not guarantee that the rows returned by FETCH FIRST N ROW ONLY are always the same N.

Related questions

GETDATE() method for DB2

I have been trying for a while now to get a similar method to GETDATE() in DB2 for i. So far I have found the following: current date current timestamp current time Would it be possible for me to: select …

Read More
Connect to AS400 using .NET

I am trying to build a .NET web application using SQL to query AS400 database. This is my first time encountering the AS400. What do I have to install on my machine (or the AS400 server) in order to connect? (…

Read More
Update 1 field in a table from another field in a different table (OS400, not a 1 to 1 relationship)

Im trying to update a field in a table from another field in a different table. The table being updated will have multiple records that need updating from 1 match in the other table. Example, i have a 1 million row sales …

Read More