MSSQL 靜態值查詢
有些時候可能會需要查詢一些靜態值
SELECT * FROM( VALUES (1), (2),(3)) AS tabName ( c1 )
演變1.多列
SELECT * FROM( VALUES (1,1), (2,2),(3,5)) AS tabName ( c1,c2 )
演變2.聚合
SELECT MAX(c1) FROM( VALUES (1), (2),(3)) AS tabName ( c1 ) SELECT SUM(c1) FROM( VALUES (1), (2),(3)) AS tabName ( c1 ) SELECT COUNT(c1) FROM( VALUES (1), (2),(3)) AS tabName ( c1 )
演變3.排序
SELECT c1 FROM( VALUES (1), (2),(3)) AS tabName ( c1 ) ORDER BY tabName.c1 SELECT c1 FROM( VALUES (1), (2),(3)) AS tabName ( c1 ) ORDER BY tabName.c1 DESC
演變4.取中間到這里就全活了.
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY c1 ) Ind, c1 FROM( VALUES (1), (2),(3)) AS tabName ( c1 ) ) tempTab WHERE tempTab.Ind=2
便于理解可以轉化成表
SELECT * FROM (SELECT ID,CName FROM Student) AS ta (id,Tname)
這里相信大家都能看懂了.有什么好的想法.歡迎給我流言.小弟不才.噴手勿擾.
浙公網安備 33010602011771號