收藏 首页 联系
  • 示例
  • 样本数据库
#1
SELECT employee_id, first_name, last_name FROM employees WHERE first_name LIKE 'Da%';
#2
SELECT employee_id, first_name, last_name FROM employees WHERE first_name LIKE '%er';
#3
SELECT employee_id, first_name, last_name FROM employees WHERE last_name LIKE '%an%';
#4
SELECT employee_id, first_name, last_name FROM employees WHERE first_name LIKE 'Jo__';
#5
SELECT employee_id, first_name, last_name FROM employees WHERE first_name LIKE '%are_';
#6
SELECT employee_id, first_name, last_name FROM employees WHERE first_name LIKE 'S%' AND first_name NOT LIKE 'Sh%' ORDER BY first_name;
表格列表
countries
SELECT * FROM countries;
departments
SELECT * FROM departments;
dependents
SELECT * FROM dependents;
employees
SELECT * FROM employees;
jobs
SELECT * FROM jobs;
locations
SELECT * FROM locations;
regions
SELECT * FROM regions;
  • SQL 查询
执行
清除 美化 缩小
重载
  • 结果