RE: [SQL] Limit Questions 2 - Mailing list pgsql-sql

From Jackson, DeJuan
Subject RE: [SQL] Limit Questions 2
Date
Msg-id D05EF808F2DFD211AE4A00105AA1B5D21006EC@cpsmail
Whole thread Raw
List pgsql-sql
sorry it would be:SELECT * FROM company_auth LIMIT 90,10;
akaSELECT * FROM company_auth LIMIT 90 OFFSET 10;
It means to give me at most 90 rows after skipping the first 10.

> > try: select * from company_auth LIMIT 10,90
> 
> What does this syntax mean?


pgsql-sql by date:

Previous
From: Mark Jewiss
Date:
Subject: Re: [SQL] finding the most recent records
Next
From: JT Kirkpatrick
Date:
Subject: combining a single field in two tables into one column.