New Row Insertion

nitin257 · #1 (**permalink**) 03-14-09, 03:46

Hi there,

if i have a table having columns "id","date","content". Now i want to extract 10 latest records. So for that do i have to first extract all record and order them in DESC by date or is it possible just to get last 10 records as new records will always be inserted in the end.

r937 · #2 (**permalink**) 03-14-09, 07:05

the former -- ORDER BY `date` DESC LIMIT 10

nitin257 · #3 (**permalink**) 03-15-09, 02:18

Thx alot mate

Internet Services

Web Development

Digital Marketing

Consumer Tech