How can I get contact first name and last name in the same column?

Anish Budha 0
Viewed 45

How can I get contact first name and last name in the same column as shown in the picture? Here is my incomplete query:

SELECT
    customernumber,
    customername,
    contactfirstname,
    contactlastname
FROM
    dbs211_customers
WHERE
    country = 'Canada'
ORDER BY
    customernumber;

Here is the link for img: https://i.stack.imgur.com/5e5C2.png

oracle sql
4 Answers

just use concatenation

SELECT customernumber, customername, CONCAT(conctractfirstname, ' ', contractlastname) as `contract_fullname` FROM dbs211_customers WHERE country = 'Canada' ORDER BY customernumber;
islemdev0

There's no picture shown in your question.

But assuming you're asking for something like this:

SELECT customernumber,
(contactfirstname + ' ' + contactlastname) AS ContactFullName
FROM dbs211_customers
WHERE country = 'Canada'
ORDER BY customernumber;
user6cVl0 
SELECT
    customernumber,
    customername,
    concat(concat(contactlastname, ', '), contactfirstname) as "Contact Name"
FROM
    dbs211_customers
WHERE
    country = 'Canada'
ORDER BY
    customernumber;
DannySlor0

Hi one way you can try is as follows.

SELECT
    customernumber,
    customername,
    contactfirstname || ' , ' ||  contactlastname
FROM
    dbs211_customers
WHERE
    country = 'Canada'
ORDER BY
    customernumber;
Himanshu Kandpal0
Related