作者jengting (~~)
看板Database
标题Re: [SQL ] 简单的排序问题,但是我不知道怎麽写.
时间Fri Feb 22 13:19:17 2013
MS SQL 写法，请参考看看 ~~
DECLARE @Temp TABLE (Num char(10) , Qty int)
INSERT INTO @Temp VALUES
('A001',0) ,
('A002',5) ,
('A003',0) ,
('A004',2) ,
('A005',0) ,
('A006',1)
SELECT *
FROM @Temp
ORDER BY IIF(Qty > 0 , 1 , 2 ) , Num
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 118.163.158.7
1F：→ kingoface:感谢大大指导! 02/22 13:28