retrieve one before the last entry

danny_brazil · #1 (**permalink**) 08-26-09, 07:41

Hello
i understand how to retrieve the last entry with DESC and LIMIT 1

but is there any way to get the second to last entry ?

Danny

mike_bike_kite · #2 (**permalink**) 08-26-09, 08:35

It isn't particularly efficient but if you're comfortable with using DESC and LIMIT then this might work:

Code:

select *
from (  select *
        from table
        order by main_field desc
        limit 2 ) tmp
order by main_field
limit 1

danny_brazil · #3 (**permalink**) 08-26-09, 09:55

some one helped me like that and its working

Go exactly like DESC and LIMIT 1, but instead of LIMIT 1 do this:

LIMIT 1,1

(LIMIT 1 actually is LIMIT 0,1)

thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech