test/sql/Distinct/exp.test001.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 echo select * from t1;
   8 ---------------------------------------------------------
   9         t1.f1   t1.f2   t1.f3   t1.f4
  10 ---------------------------------------------------------
  11         98      1       10      AAA
  12         99      2       20      BBB
  13         100     2       10      CCC
  14         101     3       10      AAA
  15         99      2       20      BBB
  16
  17 echo select distinct * from t1 ;
  18 ---------------------------------------------------------
  19         t1.f1   t1.f2   t1.f3   t1.f4
  20 ---------------------------------------------------------
  21         98      1       10      AAA
  22         99      2       20      BBB
  23         100     2       10      CCC
  24         101     3       10      AAA
  25
  26 echo select distinct f2 from t1 ;
  27 ---------------------------------------------------------
  28         f2
  29 ---------------------------------------------------------
  30         1
  31         2
  32         3
  33
  34 echo select distinct f4 from t1 ;
  35 ---------------------------------------------------------
  36         f4
  37 ---------------------------------------------------------
  38         AAA
  39         BBB
  40         CCC
  41
  42 echo select distinct f2, f4 from t1 ;
  43 ---------------------------------------------------------
  44         f2      f4
  45 ---------------------------------------------------------
  46         1       AAA
  47         2       BBB
  48         2       CCC
  49         3       AAA
  50
  51 Statement Executed