SELECT basics/zh

From SQLZOO
< SELECT basics
Revision as of 13:30, 5 January 2016 by Kenlyl (talk | contribs) (Introducing the world table of countries)
Jump to: navigation, search

Introducing the world table of countries

這個教程介紹SQL語言。我們會使用SELECT語句。on the table France:

Summary

這個例子顯示’France法國’的人口。字串應該在'單引號'中。

修改此例子,以顯示德國 Germany 的人口。

SELECT population FROM world
  WHERE name = 'France'
SELECT population FROM world
  WHERE name = 'Germany'