Learn SQL
Combining data from columns
29.1
Lesson

Concatenating data from columns

We want to display the id and name of all the students in the same column separated by a hyphen (-).

In this case, we need to concatenate data from two columns. We can use the || operator for that.

We can concatenate any combination of column data, modified column data, or plain strings together. Run the query below to get the name and marks of all students with marks combined with the string ' marks'.

Please note that the way concatenation in SQL is specified, differs from database to database. We are using Sqlite3 for this course, where the || is used for concatenation. PostgreSQL and MySQL use a CONCAT function to achieve the same. The query above would be written in MySQL or PostgreSQL as shown below.

SELECT name, CONCAT(marks, ' marks') AS marksScored
FROM students