Advertisement
Guest User

Untitled

a guest
Aug 25th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT `street`, `house`, `apartment` FROM `table`
  2.  
  3. select street || ' ' || house || ' ' || apartment as address
  4. from table
  5.  
  6. select concat(street, ' ', house, ' ', apartment) as address
  7. from table
  8.  
  9. select concat_ws(' ', street, house, apartment) as address
  10. from table
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement