Sorting:
We may specify desc fordescending order(
降序) or asc forascending order(升序), for
each attribute;ascending order is the
default. (默认升序)
– Example: order by namedesc
Can sorton multiple attributes
– Example: orderby dept_name, name
Between的使用:
select name
from instructor
where salary between 90000 and 100000
表示90000 《=salary《=100000,是一个闭区间。