Difference between revisions of "SELECT basics/zh"

From SQLZOO
Jump to navigation Jump to search
 
Line 12: Line 12:
 
    
 
    
 
<div class='qu'>
 
<div class='qu'>
The example uses a WHERE clause to show the population of 'France'.
+
這個例子顯示’France法國’的人口。字串應該在'單引號'中。
Note that strings (pieces of text that are data) should be in 'single quotes';
+
<p class='imper'>
 
+
修改此例子,以顯示德國 Germany 的人口。</p>
<p class='imper'>Modify it to show the population of Germany</p>
 
  
 
<source lang='sql' class='def'>
 
<source lang='sql' class='def'>

Revision as of 13:30, 5 January 2016

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'