How to select first 10 records in PostgreSQL?

1.	How to select first 10 records in PostgreSQL?
Answer» 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: Example select * from users ORDER by NAME desc LIMIT 0, 10

Answer»

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:

Example

select * from users ORDER by NAME desc LIMIT 0, 10

Discussion