HowTo Select firts rows

wzbn · #1 (**permalink**) 04-01-04, 14:56

Hi,

I'm looking for a way to get the firts rows of a query, (on IDS 7.3).
In other words something similar to the TOP command in MS SQL Server.

For example: "select top 100 * from tablename".

Does anyone knows Hos to do that ?

Thanks a lot

lloydnwo · #2 (**permalink**) 04-01-04, 22:24

Quote:

Originally posted by wzbn
Hi,

I'm looking for a way to get the firts rows of a query, (on IDS 7.3).
In other words something similar to the TOP command in MS SQL Server.

For example: "select top 100 * from tablename".

Does anyone knows Hos to do that ?

Thanks a lot

Hi,

Select firts 50 col1, col2 from tablename

you will have to specify the columns