Skip to content

Instantly share code, notes, and snippets.

@abarth500
Created December 2, 2014 00:58
Show Gist options
  • Save abarth500/08ea3354502ef20a4f8d to your computer and use it in GitHub Desktop.
Save abarth500/08ea3354502ef20a4f8d to your computer and use it in GitHub Desktop.
[データベースシステム論] 試行課題3
--試行課題3
---以下の2つの問い合わせの意味の違いを考えよ
--一番安いワインを得る問い合わせ その1
SELECT * FROM wine ORDER BY price LIMIT 1;
--一番安いワインを得る問い合わせ その2
SELECT * FROM wine
WHERE price= (
SELECT min(price) FROM wine);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment