select_distinct.sql 465 B

1234567891011121314151617181920
  1. --
  2. -- SELECT_DISTINCT
  3. --
  4. --
  5. -- awk '{print $3;}' onek.data | sort -n | uniq
  6. --
  7. SELECT DISTINCT two FROM tmp ORDER BY 1;
  8. --
  9. -- awk '{print $5;}' onek.data | sort -n | uniq
  10. --
  11. SELECT DISTINCT ten FROM tmp ORDER BY 1;
  12. --
  13. -- awk '{print $16;}' onek.data | sort -d | uniq
  14. --
  15. SELECT DISTINCT string4 FROM tmp ORDER BY 1;
  16. --
  17. -- Also, some tests of IS DISTINCT FROM, which doesn't quite deserve its
  18. -- very own regression file.
  19. --
  20. CREATE TEMP TABLE disttable (f1 integer);