求SQL语句：怎样只读出一个表的前10条记录？

Question

select top 10 * from yourtable

Answer 1

select top 10 * from yourtable order by col
or
set rowcount=10
select * from yourtable

Answer 2

select top 10 * from tablename

Answer 3

set rowcount=10
select * from yourtableselect top 10 * from yourtable
10-20:
select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20

Answer 4

select top 10 * from yourtable