Guest User

Untitled

a guest
Sep 25th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. CREATE TABLE foo(a,b,c)
  2. AS VALUES
  3. ( 1, 20, 1 ),
  4. ( 3, 21, 2 ),
  5. ( 1, 22, 3 ),
  6. ( 2, 22, 4 ),
  7. ( 3, 21, 5 ),
  8. ( 1, 20, 6 );
  9.  
  10. SELECT greatest(a,b), least(a,b)
  11. FROM foo
  12. GROUP BY greatest(a,b), least(a,b);
Add Comment
Please, Sign In to add comment