How to limit rows in PostgreSQL SELECT
You can use LIMIT just like in MySQL, for example:
SELECT * FROM users LIMIT 5;
You could always add the OFFSET
clause along with LIMIT
clause.
You may need to pick up a set of records from a particular offset. Here is an example which picks up 3 records starting from 3rd position:
testdb=# SELECT * FROM COMPANY LIMIT 3 OFFSET 2;
This would produce the following result:
id | name | age | address | salary
----+-------+-----+-----------+--------
3 | Teddy | 23 | Norway | 20000
4 | Mark | 25 | Rich-Mond | 65000
5 | David | 27 | Texas | 85000
Full explanation and more examples check HERE