在日常开发需求中,我们有时会遇到获取表中前n条记录的情况.
例如登录日志表 login_log_info 中有id, user_name, client_ip, login_in, create_time, brow 这几个字段。
具体数据有:
ID | USER_NAME | client_ip | LOGIN_IN | CREATE_TIME | browser_name
------------------+-------------+-----------------+----------+---------------------+-------------
067sigy4b1jrg9mm | root | 0:0:0:0:0:0:0:1 | 1 | 2018-02-08 17:05:05 | Chrome
0juhg2nyg2pivbku | root | 127.0.0.1 | 1 | 2018-02-07 07:49:02 | Chrome
1fz8h6f6al2zezbx | root | 127.0.0.1 | 1 | 2018-02-06 17:08:19 | Chrome
1lxx8ipeca0zu6un | root | 127.0.0.1 | 1 | 2018-02-06 17:22:59 | Chrome
1s5jf7ye4o5xwg3w | root | 0:0:0:0:0:0:0:1 | 1 | 2018-02-08 17:05:14 | Chrome
2v4f2dz0v975541e | root | 127.0.0.1 | 1 | 2018-03-06 14:17:40 | Chrome
3qvkrl67eze3j9nn | root