From: Martijn Tonies
Date: August 23 2004 12:44pm
Subject: Re: How to get the last record from the slected record set
List-Archive: http://lists.mysql.com/mysql/171378
Message-Id: <024901c4890e$f6dde060$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>
>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 all until you hit the last one?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com