Menu
In MySQL I can do SELECT * FROM tbl LIMIT 10
In MSSQL I can do SELECT TOP 5 * FROM tbl
How do I do this in Postgresql?
302
ROW_NUMBER (Window Function) ROW_NUMBER (Window Function) is a standard way of selecting the nth row of a table. It is supported by all the major databases like MySQL, SQL Server, Oracle, PostgreSQL, SQLite, etc.
Here's the SQL query to select every nth row in MySQL. mysql> select * from table_name where table_name.id mod n = 0; In the above query, we basically select every row whose id mod n value evaluates to zero.
If you want to select data from all the columns of the table, you can use an asterisk ( * ) shorthand instead of specifying all the column names. The select list may also contain expressions or literal values. Second, specify the name of the table from which you want to query data after the FROM keyword.
See the LIMIT clause:
SELECT * FROM tbl LIMIT 10
or
SELECT * FROM tbl OFFSET 20
and, of course
SELECT * FROM tbl LIMIT 10 OFFSET 10
From the PostgreSQL docs:
SELECT select_list
FROM table_expression
[ ORDER BY ... ]
[ LIMIT { number | ALL } ] [ OFFSET number ]
So LIMIT should work as it does in MySQL. OFFSET is used to skip rows before starting to return data.
See docs for LIMIT and OFFSET
I hope this helps.
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
