Bookmark Home Contact
  • 例
  • サンプルデータベース
#1
SELECT salary FROM employees ORDER BY salary DESC;
#2
SELECT DISTINCT salary FROM employees ORDER BY salary DESC;
#3
SELECT job_id, salary FROM employees ORDER BY job_id, salary DESC;
#4
SELECT DISTINCT job_id, salary FROM employees ORDER BY job_id, salary DESC;
#5
SELECT DISTINCT phone_number FROM employees;
テーブル一覧
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クエリ
実行
クリア ビューティファイ ミニファイ
リロード
  • 結果