Re: How to get the last record from the slected record set - Thanks

2004-08-23 Thread Manisha Sathe
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 l

RE: How to get the last record from the slected record set

2004-08-23 Thread Kerry Frater
erry -Original Message----- From: Manisha Sathe [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 14:08 To: [EMAIL PROTECTED] Subject: Re: How to get the last record from the slected record set yes, but is there any better way of doing it ? regards Manisha - Original Message - From: "Ka

Re: How to get the last record from the slected record set

2004-08-23 Thread Karl Pielorz
--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 you

Re: How to get the last record from the slected record set

2004-08-23 Thread gerald_clark
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 ar

Re: How to get the last record from the slected record set

2004-08-23 Thread Roger Baklund
* 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 M

Re: How to get the last record from the slected record set

2004-08-23 Thread 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 t

Re: How to get the last record from the slected record set

2004-08-23 Thread Manisha Sathe
: "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 > > > --On 22 August 2004 20:31 +0800 Manisha Sathe <[EMAIL PROTECTED]> > wrote: > > &

Re: How to get the last record from the slected record set

2004-08-23 Thread Martijn Tonies
> >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

Re: How to get the last record from the slected record set

2004-08-23 Thread Karl Pielorz
--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 wil

How to get the last record from the slected record set

2004-08-23 Thread Manisha Sathe
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 ? Thanks in adv