Re: LATEST N RECORDS from a table without date field

2005-08-24 Thread Jason Pyeron
On Wed, 24 Aug 2005, Harald Fuchs wrote: "Praveen KS" <[EMAIL PROTECTED]> writes: Can anyone help with a query to retrieve latest N records. No auto_increment field. No date field. Primary key exists and is populated with random unique values. This means that the only possible definition for

Re: LATEST N RECORDS from a table without date field

2005-08-24 Thread Pooly
If you don't order your data but specified a LIMIT clause, what are the records returned ? 24 Aug 2005 17:26:27 +0200, Harald Fuchs <[EMAIL PROTECTED]>: > In article <[EMAIL PROTECTED]>, > "Praveen KS" <[EMAIL PROTECTED]> writes: > > > Can anyone help with a query to retrieve latest N records. >

Re: LATEST N RECORDS from a table without date field

2005-08-24 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, "Praveen KS" <[EMAIL PROTECTED]> writes: > Can anyone help with a query to retrieve latest N records. > No auto_increment field. > No date field. > Primary key exists and is populated with random unique values. This means that the only possible definition for "late

Re: LATEST N RECORDS from a table without date field

2005-08-24 Thread Felix Geerinckx
On 24/08/2005, "Praveen KS" wrote: > Can anyone help with a query to retrieve latest N records. > > No auto_increment field. > No date field. > Primary key exists and is populated with random unique values. In a table, there are no such things as - the first record - the twenty third record

LATEST N RECORDS from a table without date field

2005-08-24 Thread Praveen KS
Can anyone help with a query to retrieve latest N records. No auto_increment field. No date field. Primary key exists and is populated with random unique values. Eg: slno int(10) primary key (populated with random unique values) name char(20) Thanks in advance. PraveenKumarKS http://www.geoci