How to select first 10 records in PostgreSQL?
To get the first 10 records from a database in PostgreSQL, use the LIMIT command.
Here is an example of picking the first 10 records from a database called Example:
BY Best Interview Question ON 19 Jun 2020
Example
select * from users order by name desc LIMIT 0, 10