Results 1 to 2 of 2
Thread: Doubt in Offset
Jul 28, 2005, 21:54 #1
Doubt in Offset
I have a table called "HelpingHands".
I have many records in the table. [I dont know the total number of records it may increase or decrease]
and i want to retrieve the last 1000 records in the table.
i used select * from HelpingHands limit (ABC),1000;
I dont know wot to substitute in the place of ABC.
Thanx in advance
Jul 29, 2005, 00:10 #2
- Join Date
- Jun 2005
- 0 Post(s)
- 0 Thread(s)
You will have to order by a certain field
(ie a datetime field, the primary key etc)
and then limit the records
Example with a datetime column
SELECT * FROM table ORDER BY datefield DESC LIMIT 1000