Hello Radhakrishnan,
lunedì, 9 novembre 98, you wrote:
RCV> how can i limit the number of rows obtained from a select statement
RCV> in postgreSQL to say, 10 rows while the select condition actually
RCV> matches more than that. in oracle we can use the ROW_NUM variable
RCV> for this purpose but now i met such an issue with postgreSQL
On v6.4 you can specify a limit for queries as:
set QUERY_LIMIT TO '10';
To have only the first 10 rows from a select;
-Jose'-