13问答网 > 一个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