hi
how to take the top 5 records in postgres
is that like this select top 5 * from table order by primary key
but its not working out
please can any one help me
chandar
-
Contributing UserDevshed Newbie (0 - 499 posts)
- Join Date
- Aug 2003
- Location
- Chennai
- Posts
- 160
- Rep Power
- 11
How to take top 5 records using select in postgres
-
No Profile PictureApprentice DeityDevshed Loyal (3000 - 3499 posts)
- Join Date
- Jul 1999
- Location
- Niagara Falls (On the wrong side of the gorge)
- Posts
- 3,237
- Rep Power
- 18
select * from table order by primaryKey limit 5
October 22nd, 2003, 12:38 AM
Reply With Quote
October 22nd, 2003, 07:58 AM
