SQL SELECT基本语句结构

(1)SELECT select_list

(2)  FROM table_list

(3)    WHERE search_conditions

      GROUP BY group_by_list

      HAVING search_conditions

(4)  ORDER BY order_list

实例:

/*USE master;
GO
IF DB_ID(N'mytest') IS NOT NULL
    DROP DATABASE mytest;
GO
CREATE DATABASE mytest;
GO

USE mytest;
GO
IF OBJECT_ID(N'dbo.Oreders') IS NOT NULL
    DROP TABLE dbo.Orders;
GO

CREATE TABLE dbo.Orders
(
    ProductID INT NOT NULL,
    MadeFrom CHAR(20),
    Sales MONEY NOT NULL
);

INSERT INTO dbo.Orders
VALUES (10,'China',100.00),
    (20,'US',500.00),
    (13,'China',10.00),
    (3,'UK',80.00),
    (2,'UK',90.00),
    (1,'US',320.00),
    (12,'Ger',214.00),
    (18,'Ger',125.00),
    (7,'JP',69.00),
    (1,'China',70.00),
    (5,'UK',560.00),
    (21,'China',211.00),
    (4,'China',89.00),
    (14,'China',100.00),
    (19,'China',100.00),
    (13,'China',100.00),
    (17,'China',100.00),
    (22,'China',100.00),
    (11,'China',100.00),
    (2,'China',100.00),
    (1,'China',100.00),
    (22,'China',100.00);
...
*/

SELECT ProductID, SUM(Sales) AS TotalSales
    FROM dbo.Orders
    WHERE MadeFrom = N'China'
    GROUP BY ProductID

    ORDER BY ProductID;

结果图:

SQL SELECT基本语句结构

SQL SELECT基本语句结构

上一篇:转:【译】CSS3:clip-path详解


下一篇:Yann LeCun, Geoffrey E. Hinton, and Yoshua Bengio