一个table表里面有100条数据,请用sql语句,将其10到20条数据写出

一个table表里面有100条数据,请用sql语句,将其10到20条数据写出
2024-11-30 06:02:00
推荐回答(2个)
回答1:

dim rs_shoujianren,sql_shoujianren
sql_shoujianren="select id,customerid from [customer] order by customerid"
set rs_shoujianren=conn.execute(sql_shoujianren)
'set rs_shoujianren=conn.execute("select id,customerid from [customer] order by customerid")

回答2:

select top 11 * from ( select top 20 * from table_name order by col1 asc ) a
order by col1 desc