[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
RE: [ic] select a specified number of records from a postgres table
> hi. i hope this is an easy question for someone. i am trying to do the
> equivalence of an Oracle ROWNUM or
> a SQLServer TOP command with postgres and cannot figure it out.
In MySQL its LIMIT:
SELECT * FROM products LIMIT 5
to return 5 rows.
Jonathan
Webmaint.
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users