Wednesday, May 30, 2007

UNION and GROUPING

Still about using UNION, how sql server grouping this result?

SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '198001'

output
------
198001
200701

(2 row(s) affected)

No comments: