数据库之数据排序

数据库之数据排序

1、–按照成绩排序(升序)

select * 
From SC
order by Grade asc(默认为升序)

2、–按照成绩排序(降序)

select *
From SC
order by desc

3、–成绩相同的按照课程号排序

select *
From SC
order by desc,Cid desc