Hi all , I tried to do a select statement below : select * from homeuser order userid limit 5; However it did not working ,it display all the records in the database. You all have any ideas how to use limit clause ?? Thanks weetat ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html