1 create table t1(f1 int,f2 int,f3 int,f4 char(10));
2 insert into t1 values(98,1,10,'AAA');
3 insert into t1 values(99,2,20,'BBB');
4 insert into t1 values(100,2,10,'CCC');
5 insert into t1 values(101,3,10,'AAA');
6 insert into t1 values(99,2,20,'BBB');
11 echo select distinct * from t1 ;
12 select distinct * from t1 ;
14 echo select distinct f2 from t1 ;
15 select distinct f2 from t1 ;
17 echo select distinct f4 from t1 ;
18 select distinct f4 from t1 ;
20 echo select distinct f2, f4 from t1 ;
21 select distinct f2, f4 from t1 ;