use Northwind
go
select EmployeeID ,CustomerID,OrderID,OrderDate
from ( select 1 as SortCol,CustomerID,EmployeeID,OrderID,OrderDate
from dbo.Orders
where CustomerID = 'ALFKI'
union all
select 2 as SortCol,CustomerID,EmployeeID,OrderID,OrderDate
from dbo.Orders
where EmployeeID = 3 )as U
order by SortCol ,
case when SortCol = 1 then OrderID end,
case when SortCol = 2 then OrderDate end desc;上面的sql语句使用示例数据库Northwind中的表Orders,当CustomerID
为ALFKI,按OrderID排当EmployeeID = 3按 OrderDate降序排这儿为什么
去掉集合操作中的别名as U会报错????
go
select EmployeeID ,CustomerID,OrderID,OrderDate
from ( select 1 as SortCol,CustomerID,EmployeeID,OrderID,OrderDate
from dbo.Orders
where CustomerID = 'ALFKI'
union all
select 2 as SortCol,CustomerID,EmployeeID,OrderID,OrderDate
from dbo.Orders
where EmployeeID = 3 )as U
order by SortCol ,
case when SortCol = 1 then OrderID end,
case when SortCol = 2 then OrderDate end desc;上面的sql语句使用示例数据库Northwind中的表Orders,当CustomerID
为ALFKI,按OrderID排当EmployeeID = 3按 OrderDate降序排这儿为什么
去掉集合操作中的别名as U会报错????
解决方案 »
- VC连接sqlite数据库
- 乱码问题
- 请问使用as后WHERE该怎么写?
- varchar 到底容量是多少?
- MSSQL连不上,Connect to serv 急~~@!!!~~~
- “存储器空间不足”的问题终得解决!!继续放分100!先进先得!10分钟内结帐!!!
- !~~~ 根据表的数据设置该表某列的数据.非常感谢来帮忙.......(在线等..在线结帐)
- SQL Server触发器应用?
- 大家好,请问如何用SQL语句将Excel中的数据转换到SQL Server的某个表中?烦请解答,谢谢!
- 更新字段的SQL语句
- 如何合并ORACLE 和SQL SERVER两个有相同的字段的表?
- 一个sql2000不能装两个相同的数据库吗?
from dbo.Orders
where CustomerID = 'ALFKI'
union all
select 2 as SortCol,CustomerID,EmployeeID,OrderID,OrderDate
from dbo.Orders
where EmployeeID = 3 ) 整个 作为了一个名为U的表来使用简写就是 select EmployeeID ,CustomerID,OrderID,OrderDate from U order by SortCol ,
case when SortCol = 1 then OrderID end,
case when SortCol = 2 then OrderDate end desc;