SQL: Concatenating Columns

Given the table below:

  • id
  • prefix
  • first
  • last
  • suffix
  • title
SELECT concat(prefix, ' ', first, ' ', last, ' ', suffix) as title FROM names;

--

--

--

My homepage to record my thought processes for solving SQL and Algorithm questions

Recommended from Medium

Nuture the Bright Spots: Dutch Exploratory Workshop on Testing 2018

The Whole Story About f-strings in Python

Mines of Dalarnia Testnet — Update 1 Patch Notes (03.08.2022)

Simple Terminal Command Steps for JavaScript React/Ruby on Rails Applications

Fusio 2.0: An PHP based API management platform

KIRA Launches Public Testnet

Selling Beer in a Trustless Data Ecosystem

Boxes showing the simplified data sets, for two retailers & a wholesaler (Stock levels & Sales), two brewers (stock levels & brewing capacity), two logistics companies (delivery times & network capacity) and the tournament (results)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Jen-Li Chen

Jen-Li Chen

In love with telling stories with data

More from Medium

Wildchard and Constrain SQL

My first steps in learning SQL

INTRODUCTION TO SQL

Types of Relationship in Database