摘要: --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 = 你指定的数值. 阅读全文
posted @ 2010-12-31 11:17 yiyan21 阅读(1543) 评论(0) 推荐(1) 编辑