这条SQL语句是怎么了??
USE NorthWind
CREATE TABLE AAA(id int, num int)
INSERT AAA VALUES(1,2)
INSERT AAA VALUES(1,3)
INSERT AAA VALUES(2,5)
INSERT AAA VALUES(3,7)
SELECT distinct [id], num FROM AAA
为什么结果中还有重复的id??
id num
----------- -----------
1 2
1 3
2 5
3 7
(4 row(s) affected)