distinct_star.sql 249 B

123456789
  1. /* syntax version 1 */
  2. use plato;
  3. select distinct * from Input2 order by key, subkey;
  4. select distinct * without subkey from Input2 order by key, value;
  5. select distinct a.*, TableName() as tn, without subkey from Input2 as a order by key, value;