摘要:
--sql 2000select * from(select * ,number = (select count(*) from tb where id t.id) + 1 from table t) m where number = 你指定的数值.--sql 2005select * from(select * , number = row_number() over(order by id) from table ) m where number = 你指定的数值. 阅读全文