非淡泊无以明志，非宁静无以致远

关于SELECT

這個教程介紹SQL語言。我們會使用SELECT語句。我們會使用WORLD表格 name continent area population gdp Afghanistan Asia 652230 25500100 20343000000 Albania Europe 28748 2831741 129600000

我們繼續練習簡單的單一表格SQL查詢。 這個教程是有關諾貝爾獎得獎者的： nobel(yr, subject, winner) yr subject winner 1960 Chemistry Willard F. Libby 1960 Literature Saint-John Perse 1960 Medicin

This tutorial looks at how we can use SELECT statements within SELECT statements to perform more complex queries. name continent area population gdp Afghanistan Asia 652230 25

World Country Profile: Aggregate functions This tutorial is about aggregate functions such as COUNT, SUM and AVG. An aggregate function takes many values and delivers just one value. For example th

id mdate stadium team1 team2 1001 8 June 2012 National Stadium, Warsaw POL GRE 1002 8 June 2012 Stadion Miejski (Wroclaw) RUS CZE 1003 12 June 2012 Stadion Miejski (Wrocla

Movie Database This tutorial introduces the notion of a join. The database consists of three tables movie , actor and casting . movie actor casting id id movieid title

teacher id dept name phone mobile 101 1 Shrivell 2753 07986 555 1234 102 1 Throd 2754 07122 555 1920 103 1 Splint 2293   104   Spiregra

stops(id, name) route(num,company,pos, stop) stops route id num name company   pos   stop     1、How many stops are in the database.

name continent Afghanistan Asia Albania Europe Algeria Africa Andorra Europe Angola Africa .... name:國家名稱 continent:洲份 1、 你可以用WHERE name LIKE 'B%'

关于SELECT的使用