select sum(OrderID) from (SELECT TOP 100 PERCENT * FROM T_InOrderInfo where 1 = 1 and IsDelete=0 and OrderID = 1 and OperatingPersonnel='wy' Order by RegTime DESC)
这里用ORDER有意吗?你这语句, select sum(OrderID) from (SELECT * FROM T_InOrderInfo where 1 = 1 and IsDelete=0 and OrderID = 1 and OperatingPersonnel='wy' Order by RegTime DESC) 除了语法错误,与这语句的语意有区别吗? SELECT SUM(OrderID) FROM T_InOrderInfo where 1 = 1 and IsDelete=0 and OrderID = 1 and OperatingPersonnel='wy'
加了TOP统计的数据可能就不楼主的本意了。
fcuandy(要学的东西还很多) ,SELECT TOP 100 PERCENT * 和SELECT * 的效果是一樣的
楼主这句话中,order by 不起作用啊,去掉效果一样,反正求和 select sum(OrderID) from (SELECT * FROM T_InOrderInfo where 1 = 1 and IsDelete=0 and OrderID = 1 and OperatingPersonnel='wy' Order by RegTime DESC)
select sum(OrderID) from (SELECT * FROM T_InOrderInfo where 1 = 1 and IsDelete=0 and OrderID = 1 and OperatingPersonnel='wy' Order by RegTime DESC)
除了语法错误,与这语句的语意有区别吗?
SELECT SUM(OrderID) FROM T_InOrderInfo where 1 = 1 and IsDelete=0 and OrderID = 1 and OperatingPersonnel='wy'
select sum(OrderID) from (SELECT * FROM T_InOrderInfo where 1 = 1 and IsDelete=0 and OrderID = 1 and OperatingPersonnel='wy' Order by RegTime DESC)