数据库之数据排序
1、–按照成绩排序(升序)
select *
From SC
order by Grade asc(默认为升序)
2、–按照成绩排序(降序)
select *
From SC
order by desc
3、–成绩相同的按照课程号排序
select *
From SC
order by desc,Cid desc
1、–按照成绩排序(升序)
select *
From SC
order by Grade asc(默认为升序)
2、–按照成绩排序(降序)
select *
From SC
order by desc
3、–成绩相同的按照课程号排序
select *
From SC
order by desc,Cid desc