What does SQL Select symbol || mean?

by

|| represents string concatenation. Unfortunately, string concatenation is not completely portable across all sql dialects:

  • ansi sql: || (infix operator)
  • mysql: concat ( vararg function ). caution: || means ‘logical or’ (It’s configurable, however; thanks to @hvd for pointing that out)
  • oracle: || (infix operator), concat ( caution: function of arity 2 only ! )
  • postgres: || (infix operator)
  • sql server: + (infix operator), concat ( vararg function )
  • sqlite: || (infix operator)

hopefully the confusion is complete …

More Related Contents:

  1. In SQL Server how to get the count of child if both parent and child are available [closed]
  2. How to select the nth row in a SQL database table?
  3. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  4. SQL: Repeat a result row multiple times, and number the rows
  5. In MySQL, should I quote numbers or not?
  6. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  7. Does mysql have the equivalent of Oracle’s “analytic functions”?
  8. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  9. Use Composite Primary Key as Foreign Key
  10. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  11. Why in SQL NULL can’t match with NULL?
  12. SQL Query needed for fetch value from Two identical table but not fully identical table
  13. How to create a MySQL hierarchical recursive query?
  14. Error related to only_full_group_by when executing a query in MySql
  15. How to reset AUTO_INCREMENT in MySQL
  16. How to declare a variable in MySQL?
  17. MySQL Query GROUP BY day / month / year
  18. MySQL Cannot Add Foreign Key Constraint
  19. Grouping into interval of 5 minutes within a time range
  20. SQL counting all rows instead of counting individual rows
  21. MySQL Like multiple values
  22. MySQL add days to a date
  23. mysql dynamic query in stored procedure
  24. Check for x consecutive days – given timestamps in database
  25. How to alter a column and change the default value?
  26. How to select one row randomly taking into account a weight?
  27. MySQL – Replace Character in Columns
  28. MySQL Select minimum/maximum among two (or more) given values
  29. MySQL – SELECT * INTO OUTFILE LOCAL ?
  30. ORDER BY alphabet first then follow by number

Leave a Comment