Finding first four in list

[dc_jt]

Hi

 

I have a table like the following:

 

offer_id    name      ordering

1            test              5

2            test 2          4

3            test 3          3

4            test 6          2

5            test 5          1

 

As I enter more, they go to the top so the next one would have ordering 6.

 

How do I find the first four? ( test, test2, test3 and test 4) I.e The latest ones added?

 

Thanks

[neel_basu]

SQL :

select `name` from `table_name` order by `offer_id` ASC limit 4

[jitesh]

select * from table order by ordering DESC limit 0,4

[jitesh]

If offer_id is primary key and auto incremented then

select * from table order by `offer_id` DESC limit 0,4