How to limit rows in PostgreSQL SELECT

sql postgresql sql-limit
Dan Mertz picture Dan Mertz · Jul 15, 2009 · Viewed 103k times · Source

What's the equivalent to SQL Server's TOP or DB2's FETCH FIRST or mySQL's LIMIT in PostgreSQL?

Answer

Sinan Taifour picture Sinan Taifour · Jul 15, 2009

You can use LIMIT just like in MySQL, for example:

SELECT * FROM users LIMIT 5;

Related questions

How to get the top 10 values in postgresql?

I have simple question: I have a postgresql database: Scores(score integer). How would I get the highest 10 scores the fastest? UPDATE: I will be doing this query multiple times and am aiming for the fastest solution.

Read More
Best way to get result count before LIMIT was applied

When paging through data that comes from a DB, you need to know how many pages there will be to render the page jump controls. Currently I do that by running the query twice, once wrapped in a count() to …

Read More
Limit join to one row

I have the following query: SELECT sum((select count(*) as itemCount) * "SalesOrderItems"."price") as amount, 'rma' as "creditType", "Clients"."company" as "client", "Clients".id as "ClientId", "Rmas".* FROM "Rmas" JOIN "EsnsRmas" on("EsnsRmas"."RmaId" = "Rmas"."id") JOIN "Esns" on ("Esns".…

Read More