Limiting SQL queries is most likely a useful feature especially if you want to get a sample data chunk from a big table. The
LIMIT clause in PostgreSQL is pretty much the same as the MySQL equivalent.
SELECT some_columns FROM table_name ORDER BY some_column LIMIT number_of_rows OFFSET skip_first_n_rows;
OFFSETclause serves to skip the first N rows. If you don’t specify it though, default value is
NULLand there will be no row skips.
ORDER BYis a good approach if you want the result rows to be returned in a consistent unique order.