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
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.
>
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
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
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