--On 22 August 2004 20:31 +0800 Manisha Sathe [EMAIL PROTECTED]
wrote:
I am having more than 10 records in a table. I want to select only first
top 10 records (depending on one field score) and then want to select
10th position record.
select * from table1 order by score desc LIMIT 10
This will
I am having more than 10 records in a table. I want to select only first
top 10 records (depending on one field score) and then want to select 10th
position record.
select * from table1 order by score desc LIMIT 10
This will give me 10 records but then how to get the last record ?
Cycle them
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
regards
Manisha
- Original Message -
From: Karl Pielorz [EMAIL PROTECTED]
To: Manisha Sathe
yes, but is there any better way of doing it ?
regards
Manisha
- Original Message -
From: Karl Pielorz [EMAIL PROTECTED]
To: Manisha Sathe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, August 23, 2004 8:34 PM
Subject: Re: How to get the last record from the slected record set
* Manisha Sathe
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
Try this:
order by score desc LIMIT 9,1
--
Roger
--
MySQL General Mailing
Manisha Sathe wrote:
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
regards
Manisha
order by score desc limit 9,1
--
MySQL General Mailing List
For list
--On 22 August 2004 21:05 +0800 Manisha Sathe [EMAIL PROTECTED]
wrote:
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
I'm not quite sure I follow what
Hi,
I don'e know if this will help as I am probably only one step ahead of you
here, but if it does great. If not you can just delete it.
How are you going to access the data? Via a program, PHP, using queries?
I am a newbie to this area myself, and use Delphi.
I know that using Delphi with
Thanks to all of, I could get it
Thanks
Manisha
- Original Message -
From: Karl Pielorz [EMAIL PROTECTED]
To: Manisha Sathe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, August 23, 2004 9:52 PM
Subject: Re: How to get the last record from the slected record set
--On 22