t_user表:
+---------+-----------+----------+-------------+-------+---------------------+
| user_id | user_name | password | contact_tel | email | create_date |
+---------+-----------+----------+-------------+-------+---------------------+
| a1234 | qwert | qwerty | NULL | NULL | 2009-06-02 21:31:28 |
| asdf | asdf | asdfgh | NULL | NULL | 2009-06-02 21:31:11 |
| b1234 | zxcv | asdfgh | NULL | NULL | 2009-06-02 21:31:41 |
| c1234 | rtuur | asdfgh | NULL | NULL | 2009-06-02 21:31:56 |
| d1234 | fghj | asdfgh | NULL | NULL | 2009-06-02 21:32:20 |
| e1234 | sdfg | asdfgh | NULL | NULL | 2009-06-02 21:32:37 |
| f1234 | egfujhry | wertyu | NULL | NULL | 2009-06-02 21:32:49 |
| g1234 | qwertt | asdfgh | NULL | NULL | 2009-06-02 21:32:57 |
| root | 管理员 | root123 | NULL | NULL | NULL |
+---------+-----------+----------+-------------+-------+---------------------+
select * from t_user order by create_date desc limit 1, 3;
结果:
+---------+-----------+----------+-------------+-------+---------------------+
| user_id | user_name | password | contact_tel | email | create_date |
+---------+-----------+----------+-------------+-------+---------------------+
| f1234 | egfujhry | wertyu | NULL | NULL | 2009-06-02 21:32:49 |
| e1234 | sdfg | asdfgh | NULL | NULL | 2009-06-02 21:32:37 |
| d1234 | fghj | asdfgh | NULL | NULL | 2009-06-02 21:32:20 |
+---------+-----------+----------+-------------+-------+---------------------+