程式設計

請選擇下方類別,查看您想了解的「程式設計」知識。

  • 資料庫程式設計
  • import_contacts SELECT
    157
適用範圍

從指定的資料表中,查詢的某筆欄位的所有資料 SELECT 欄位1, 欄位2, ... FROM 資料表;

實用性:
重要性:

SQL SELECT

SELECT“欄位名稱” FROM“表格名稱”; 我們用以下的例子來實作: 北風資料庫 (Northwind)

Customers 的資料表

SELECT * FROM Customers ;

CustomerID CompanyName ContactName Address City PostalCode Country
ALFKI Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany
ANATR Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constitucion 2222 Mexico D.F. 05021 Mexico
ANTON Antonio Moreno Taqueria Antonio Moreno Mataderos 2312 Mexico D.F. 05023 Mexico
AROUT Around the Horn Thomas Hardy 120 Hanover Sq. London WA1 1DP UK
BERGS Berglunds snabbkop Christina Berglund Berguvsvagen 8 Lulea S-958 22 Sweden
BLAUS Blauer See Delikatessen Hanna Moos Forsterstr. 57 Mannheim 68306 Germany
BLONP Blondesddsl pere et fils Frederique Citeaux 24, place Kleber Strasbourg 67000 France
BOLID Bolido Comidas preparadas  Martin Sommer C/ Araquil, 67 Madrid 28023 Spain
BONAP Bon app'  Laurence Lebihan 12, rue des Bouchers Marseille 13008 France
BOTTM Bottom-Dollar Markets Elizabeth Lincoln 23 Tsawassen Blvd. Tsawassen T2F 8M4 Canada

備註:星號(*)為查詢所有列的參數

從資料表中選出所有公司名稱 CompanyName

SELECT CompanyName FROM Customers ;

結果:

CompanyName
Alfreds Futterkiste
Ana Trujillo Emparedados y helados
Antonio Moreno Taqueria
Around the Horn
Berglunds snabbkop
Blauer See Delikatessen
Blondesddsl pere et fils
Bolido Comidas preparadas 
Bon app' 
Bottom-Dollar Markets