SQL SELECT基本语句结构
2024-08-28 21:36:02
(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;
结果图:
最新文章
- JQuery.Ajax之错误调试帮助信息
- requestWindowFeature(Window.FEATURE_NO_TITLE)无效解决方法
- Node.js的函数返回值
- atexit函数和两种特殊文件权限位
- iOS开发笔记5:多线程之NSThread、NSOperation及GCD
- 话说 依赖注入(DI) or 控制反转(IoC)
- C#执行参数为游标 返回一个记录集的Oracle存储过程
- 2. QT窗体间值的传递
- LCD与ARM,具体
- Xshell和VirtualBox虚机CentOS7的连接
- 集群下Cookie共享,必须要设置machineKey
- 20190312_浅谈go&;java差异(一)
- 从C过渡到C++的几个知识点(结构体、引用、重载运算符)
- InnoDB-MVCC与乐观锁
- python接口自动化测试(二)-requests.get()
- 最大公约数gcd与最小公倍数lcm
- 【洛谷p1106】删数问题
- Sublime Text怎么快速建立一个html5页面模板
- Percona XtraDB Cluster高可用与状态快照传输(PXC 5.7 )
- linux命令学习之:cd