通过查询语句select * from user where id=1 我不知道你这个username指的是不是字段,如果是要取出表中某个字段的值。 可以通过select 字段名1,字段名2 ... from user where id=1。-- MS sql server2005以上,ORACLE select * from (select row_number() over ( order by starttime asc) as rownum,* from steriworkrecord where starttime between '2013-11-1' and '2013-12-31') awhere rownum between 2 and 10-- 【注意( order by starttime asc)是你排序的