concatenation operator || (doesnt work on all DBs)

PHOTO

Tue Aug 08 2023 04:29:57 GMT+0000 (Coordinated Universal Time)

Saved by @vnmshenoy

SELECT first_name || ' ' || last_name 
as name
from copywriter

----- other db
SELECT CONCAT(first_name,' ',last_name) AS name
FROM copywriter;

https://learnsql.com/course/standard-sql-functions/numeric-functions/concatenation/concatenation-operator

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

SQL

@vnmshenoy

SQL Basics - SQL online course | LearnSQL.com SQL Basics - SQL online course | LearnSQL.com SQL Basics - SQL online course | LearnSQL.com select year from date interesting having clause eg order by the summed value groupby full query SQLLearn All/Any operator-really interesting SQL Basics - SQL online course | LearnSQL.com Find Out How To Use Filtering In SQL JOINs - Vertabelo Academy Online Interactive Course Improve Your Knowledge By Learning SQL Multiple JOINs - Vertabelo Academy Online Interactive Course Learn How To Use SQL JOINs To Self JOIN Tables - Vertabelo Academy Online Interactive Course Improve Your Skills By Learning Non-Equi Self JOIN - Vertabelo Academy Online Interactive Course Learn How To Use Non-Equi SQL JOINs -We also don't have to use the equality operator when joining tables. We are free to use other comparison operators (<, >, <=, >=, !=, <>) or the BETWEEN operator: use of MOD(patient.id, 2) = 1 . if you need to find odd id's instead of say using in (1,3,5,7,....) use Mod what i liked about this is that the answer provided had used "AND" between joins as well Multiple Filtered SQL JOIN - Vertabelo Academy Online Interactive Course Multiple Non-Equi JOINs Practice - self join table pe join on non-equi join and not primary key concatenation operator || (doesnt work on all DBs) Inbuilt SQL functions

Browse more snippets >>