List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 1 2000 5:17pm
Subject:Re: rowcount
View as plain text  
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
Thread
rowcountamir1 Apr
  • RE: rowcountindrek siitan1 Apr
  • Re: rowcountFaisal Nasim1 Apr
    • Re: rowcountPaul DuBois1 Apr