Re: [SQL ] 簡單的排序問題,但是我不知道怎麼寫.

[jengting (~~)]

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
→ kingoface:感謝大大指導!