Question

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

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

Answer 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")

Answer 2

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