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)
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:
Post a Comment