Re: Use of the LIMIT clause ?

it's like
SELECT *
FROM :table
WHERE :condition
LIMIT :limit
OFFSET :offset

Sherwin

bayet(at)enseirb(dot)fr writes:
>I read on a website dedicated to MySQL, that the limit clause allows
>someone to restrict the result of a query to a certain domain.
>Exemple : "select id, title from movie order by id limit 3" -> only the
>(here, first) 3 lines of the table
>I did knew about this, but the author goes further about the "limit
>N,P", which allows someone to get only results between the Nth and Pth
>lines of the whole result...
>I tried this with psql, but couldn't get anything but parse errors.
>However, "\h select" does mention "LIMIT [count, all] {offset, START}"
>So, is it possible or not ? And what's the correct syntax ?
>
>Thanks
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster