On Tue, 26 Nov 2002 15:01:08 -, Tom Place wrote:
>a simple way in MySQL to only select the first x rows
See LIMIT:
http://www.mysql.com/doc/en/SELECT.html
- Steve Yates
- If at first you don't succeed, then skydiving isn't for you.
~ Taglines by Taglinator - www.srtware.com ~
St
> Is there a simple way in MySQL to only select the first x rows that meet
> a specified criteria.
> For example in Oracle the following would work:
> Select * from Blah where stuff="true" and rownum <= 10
? (where rownum is not a specific column, just a count of how many rows
> have been retu
Tom,
Tuesday, November 26, 2002, 5:01:08 PM, you wrote:
TP> Is there a simple way in MySQL to only select the first x rows that meet
TP> a specified criteria.
TP> For example in Oracle the following would work:
TP> Select * from Blah where stuff="true" and rownum <= 10
TP> (where rownum is not a
Hi,
Select * from Blah where stuff="true" limit 10;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Tom Place" <
Tom Place wrote:
Hi All,
Is there a simple way in MySQL to only select the first x rows that meet
a specified criteria.
For example in Oracle the following would work:
Select * from Blah where stuff="true" and rownum <= 10
(where rownum is not a specific column, just a count of how many rows
ha
There is SQL function called COUNT. Check it out and
see of that helps you.
Pae
> Hi All,
>
> Is there a simple way in MySQL to only select the first x rows that meet
> a specified criteria.
>
> For example in Oracle the following would work:
>
> Select * from Blah where stuff="true" and rown
