SQL SELECT基本语句结构

时间:2022-04-02 13:24:36

(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
    HAVING SUM(Sales) > 150
    ORDER BY ProductID;

 

结果图:

SQL SELECT基本语句结构

SQL SELECT基本语句结构