At 11:37 AM +0500 2000-04-01, Faisal Nasim wrote:
>: Hello,
>:
>: I am working on a SELECT statement:
>: SELECT id FROM EmailDatabase WHERE username='joe' AND
>: EmailBox='Inbox';
>:
>: But at times when there are a lot of emails, it may
>: return thousands of rows. Is there any way to return
>: only the first 'x' rows from the query?
>
>Check out the LIMIT clause for SELECT.
>
>SELECT * FROM blah LIMIT x
>
>Where 'x' is a valid numeric integer/column.
>
>Faisal
No, 'x' must be a constant.
--
Paul DuBois, paul@stripped
