sqlserver while循环（sqlserverwhile循环表）

科技前沿 • 2025-04-19 23:20 • 阅读 46

大家好，我是讯享网，很高兴认识大家。

 <p>SELECT T1.* FROM (SELECT 未来之窗.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT count(Name) order_count,sum(NowPrice) yye,sum(EmpAchieve) yj FROM emp_performance WHERE ( (CreateDate BETWEEN &#39;2024-09-04 00:00:00&#39; AND &#39;2024-11-04 23:59:59&#39; ) ) AND ( EmployeePost &#61; &#39;0001&#39; ) AND ( EmpCode &#61; &#39;006&#39; ) AND ( ItemClass &#61; &#39;00000001&#39; ) AND ( Specify &#61; 0 )) AS 未来之窗) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1)</p>

讯享网

1> SELECT T1.* FROM (SELECT thinkphp., ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT EmpCode,EmpName,count(Name) order_count,sum(NowPrice) yye,sum(EmpAchieve) yj FROM emp_performance WHERE ( (CreateDate BETWEEN ‘2024-09-04 00:00:00’ AND ‘2024-11-04 23:59:59’ ) ) AND ( EmployeePost = ‘0001’ ) AND ( MemCode = ‘notnull’ ) GROUP BY EmpCode) AS thinkphp) AS T1
2> go
42000 - [SQL Server]选择列表中的列 ‘emp_performance.EmpName’ 无效，因为该列没有包含在聚合函数或 GROUP BY 子句中。
1> SELECT T1. FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT EmpCode,EmpName,count(Name) order_count,sum(NowPrice) yye,sum(EmpAchieve) yj FROM emp_performance WHERE ( (CreateDate BETWEEN ‘2024-09-04 00:00:00’ AND ‘2024-11-04 23:59:59’ ) ) AND ( EmployeePost = ‘0001’ ) AND ( GuestSex = ‘女客’ ) GROUP BY EmpCode,EmpName) AS thinkphp) AS T1
2> go
+———+———-+————-+——–+———-+————+
| EmpCode | EmpName | order_count | yye | yj | ROW_NUMBER |
+———+———-+————-+——–+———-+————+
| 01 | 吕柯 | 55 | 14083 | 11229.85 | 1 |
| 03 | 力波 | 11 | 1292 | 1069.15 | 2 |
| 05 | 小峰 | 30 | 5140.8 | 4351.86 | 3 |
| 06 | 六小龄童 | 11 | 744 | 653.6 | 4 |
| 201 | 另一 | 37 | 4778 | 4076.55 | 5 |
+———+———-+————-+——–+———-+————+
(5 rows affected)

讯享网

sqlserver while循环（sqlserverwhile循环表）

相关推荐