set the number of rows returned in a query

[johny.cbi]

How to set the number of rows returned in a query?

I want to limit only the first 100 rows
need it at the query level  not in the report
if i try setting "Maximum Rows Retrieved" under the query properties,
it gives an error if I try to get more records back then the maximum
I just basically want to use a "LIMIT" in SQL on the query
at report level we can set no of rows per page

[DSR]

If you want to set no of rows at query level...

You can ristrict by FM.... But it is applicable for all reports available in project under that particular package...........


Just think if you want to apply for all reports then this can solve your problem..

Bye..........

[Suraj]

Try using rank function.