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
have been returned)
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 rownum = 10
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
have
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 5:01 PM
Subject: SQL Row Counting in MySQL
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
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
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 returned)
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 ~