How to skip the last record and output the second record an the rest 2

[mperez5]

Hello All,
I need help in How to skip the last record and output the second record an the rest. I greatly appreaciate any help.
This is what I have so far:

SELECT my_id, name, lastName, my_date, myTitle
FROM myRecords
where myTitle='supervisor'
order by ReleaseDate desc limit 3


table name myRecords
my_id name lastName my_date myTitle
1 John Smith 2006-02-08 00:00:00 supervisor
2 Frank White 2006-02-02 00:00:00 supervisor
3 susan jones 2006-01-08 00:00:00 manager
4 jane webster 2006-01-02 00:00:00 supervisor
5 gina beck 2005-12-08 00:00:00 supervisor

Desire output
2 Frank White 2006-02-02 00:00:00 supervisor
4 jane webster 2006-01-02 00:00:00 supervisor
5 gina beck 2005-12-08 00:00:00 supervisor

 

[towerbase]

LIMIT can take two arguments. Your requirement can be met if you use the two argument option.

Check out the online documentation at

http://www.mysql.com

Andrew
Hampshire, UK

 

[r937]

could you please explain how you managed to skip not only the latest date (id 1) but also the third latest (id 3)

r937.com | rudy.ca

 

[guelphdad]

user 3 is not a supervisor.

 

[r937]

ah yes, thanks guelphdad

in that case, go with towerbase's suggestion



r937.com | rudy.ca

 

[mperez5]

I got it, thanks towerbase and Guelphdad

SELECT my_id, name, lastName, my_date, myTitle
FROM myRecords
where myTitle='supervisor'
order by ReleaseDate desc limit 1, 3