SQL点滴一:借row_number()函数更新排序字段值
摘要: create table t1(c1 int ,c2 int)insert t1(c1,c2) values(5,10)insert t1(c1,c2) values(3,20)insert t1(c1,c2) values(4,30)insert t1(c1,c2) values(2,40)insert t1(c1,c2) values(1,50)select * from t1c1 c2---...
阅读全文
posted @
2009-01-22 14:57 闫力昕 阅读(179) |
评论 (0) 编辑