[SOLVED] mysql - how do I choose the 2nd most recent item?

[izbryte]

I have a script that selects the most recent inputted item for display:

$query = "SELECT *FROM jobs DESC LIMIT 1";		

Is there an easy way to select the 2nd most recent or 3rd?

[hitman6003]

$query = "SELECT *FROM jobs DESC LIMIT 1, 1";	//selects the second item

[izbryte]

k, gotcha! thanks!