Skip to content

Instantly share code, notes, and snippets.

@alexanderjsingleton

alexanderjsingleton/gist:54963903a2b130ecf3c4

Created February 18, 2016 15:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexanderjsingleton/54963903a2b130ecf3c4 to your computer and use it in GitHub Desktop.
Save alexanderjsingleton/54963903a2b130ecf3c4 to your computer and use it in GitHub Desktop.
Download ZIP
[That feeling when I land a big-ass query on the first try...](http://imgur.com/9VQyUb1)
Raw
gistfile1.txt
SELECT CONCAT(CONCAT(CONCAT(CONCAT(city, ' '),STATE),' '),zip) AS "All together with Concat"
FROM student.zipcode;
@alexanderjsingleton
Copy link
Author

Concatenate multiple columns into one using only the CONCAT function.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment