sql查询表怎么样查询前后10行

用union all吧 select top 10 from [tablename] order by [col] union all select top 10 from [tablename] order by [col] desc

-- mysql select * from table_name order by id desc limit 0,10 --oracle select * from (select * from table_name order by id desc) t where rownum<=10