Utopiaes

摘要： 搞了几个小时才搞好 真的是要学习的太多了declare @index int set @index=1 //定义索引SELECT * FROM ( select row_number() over( order by sno) as //使用row_number()根据sno排序加编号row_number1,sno,[money],sname,score,cname from ( select student.sno,[money],sname,score,cname //多表查询出数据from (stu... 阅读全文