ブックマーク ホーム 連絡先
  • 例
  • サンプルデータベース
#1
SELECT MIN(salary) FROM employees;
#2
SELECT employee_id, first_name, last_name, salary FROM employees WHERE salary = ( SELECT MIN(salary) FROM employees );
#3
SELECT department_id, MIN(salary) FROM employees GROUP BY department_id;
#4
SELECT d.department_id, department_name, MIN(salary) FROM employees e INNER JOIN departments d ON d.department_id = e.department_id GROUP BY d.department_id;
#5
SELECT d.department_id, department_name, MIN(salary) FROM employees e INNER JOIN departments d ON d.department_id = e.department_id GROUP BY d.department_id ORDER BY MIN(salary);
#6
SELECT d.department_id, department_name, MIN(salary) FROM employees e INNER JOIN departments d ON d.department_id = e.department_id GROUP BY e.department_id HAVING MIN(salary) < 3000;
テーブル一覧
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クエリ
実行
クリア 整形 最小化
リロード
  • 結果