1.使用以下语句:
姓名升序:
SELECT first_name,last_name,department_id,salary
FROM employees ORDER BY first_name ASC
结果如下:
使用以下语句:
年薪降序:
SELECT first_name,last_name,department_id,salary
FROM employees ORDER BY salary DESC
结果如下:
2.使用以下语句:
SELECT first_name,last_name,department_id,salary
FROM employees WHERE salary<8000 or salary>17000
ORDER BY salary DESC
结果如下:
3.使用以下语句:
SELECT*
FROM employees WHERE email LIKE '%e%'
ORDER BY LENGTH(email) DESC
结果如下:
邮箱字节数