收藏 主页 联系
  • 示例
  • 示例数据库
#1
SELECT employee_id, first_name, last_name, hire_date, salary FROM employees;
#2
SELECT employee_id, first_name, last_name, hire_date, salary FROM employees ORDER BY first_name;
#3
SELECT employee_id, first_name, last_name, hire_date, salary FROM employees ORDER BY first_name, last_name DESC;
#4
SELECT employee_id, first_name, last_name, hire_date, salary FROM employees ORDER BY salary DESC;
#5
SELECT employee_id, first_name, last_name, hire_date, salary FROM employees ORDER BY hire_date;
#6
SELECT employee_id, first_name, last_name, hire_date, salary FROM employees ORDER BY hire_date DESC;
表格列表
国家
SELECT * FROM countries;
部门
SELECT * FROM departments;
家属
SELECT * FROM dependents;
员工
SELECT * FROM employees;
工作
SELECT * FROM jobs;
地区
SELECT * FROM locations;
大区
SELECT * FROM regions;
  • SQL 查询
执行
清除 美化 最小化
重新加载
  • 结果