ブックマーク ホーム 問い合わせ
  • 例
  • サンプルデータベース
#1
SELECT first_name, last_name, job_id, salary FROM employees WHERE job_id = 9 AND salary > 5000;
#2
SELECT first_name, last_name, hire_date FROM employees WHERE CAST(strftime('%Y',hire_date) AS INTEGER) >=1997 AND CAST(strftime('%Y',hire_date) AS INTEGER) <= 1998;
テーブルリスト
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クエリ
実行
クリア 整形 縮小
再読み込み
  • 結果