一、给定一张表1,根据要求进行排序:
+--------+----------+---------+----------+
| emp_id | emp_name | dept_id | emp_wage |
+--------+----------+---------+----------+
| 1001 | toni | 1 | 32000 |
| 1002 | lMcy | 3 | 2500 |
| 1003 | toM | 4 | 3200 |
| 1004 | mamy | 2 | 9500 |
+--------+----------+---------+----------+
1.根据emp_wage,员工工资升序排序:mysql> select * from employee order by emp_wage ASC; (注:ASC=ascending升序)
+--------+----------+---------+----------+
| emp_id | emp_name | dept_id | emp_wage |
+--------+----------+---------+----------