这个sql语句怎么写?
name date Flag
1 2012-01-01 A
1 2012-01-01 A
1 2012-01-01 B
1 2012-01-01 C
1 2012-01-01 C
2 2012-01-01 A
2 2012-01-01 C
2 2012-01-01 C
1 2012-01-02 A
1 2012-01-02 A
1 2012-01-02 B
1 2012-01-02 C
1 2012-01-02 C
2 2012-01-02 A
2 2012-01-02 C
2 2012-01-02 C
想过使name、date、Flag同时重复的数据只输出一个,请问sql语句怎么写?
例如:
1 2012-01-01 A
1 2012-01-01 A
1 2012-01-01 B
1 2012-01-01 C
1 2012-01-01 C
则输出:
1 2012-01-01 A
1 2012-01-01 B
1 2012-01-01 C