ブックマーク ホーム お問い合わせ
  • 例
  • サンプルデータベース
#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;
テーブルリスト
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クエリ
​x
 
1
​
実行
クリア 美化 最小化
リロード
  • 結果