티스토리 뷰

정보 보관 ver1.0

MS SQL 에는 DUAL 이 없다.

James Wetzel 2011. 6. 15. 17:33

http://joshua90.tistory.com/12

SELECT  '30대' AS ageGroup, SUM(scope) AS scope
FROM     (SELECT  COUNT(*) AS scope, birthDay
                FROM     Pie
                WHERE  (birthDay BETWEEN 1982 AND 1992)
                GROUP BY birthDay) AS virtualTable
728x90
반응형
저작자표시 (새창열림)