Consider the following dataset which contains information about houses that are for sale:
Which of the following string manipulation commands will combine the address and region name columns to create a full address?
full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan

Question

Consider the following dataset which contains information about houses that are for sale:

Which of the following string manipulation commands will combine the address and region name columns to create a full address?

full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan

David Powell · Accepted Answer

SELECT CONCAT(address, ' , ' , regionname) AS full_address FROM melb LIMIT 5;

David Powell · Answer

SELECT CONCAT(address, '-' , regionname) AS full_address FROM melb LIMIT 5;

David Powell · Answer

SELECT CONCAT(regionname, ' , ' , address) AS full_address FROM melb LIMIT 5

David Powell · Answer

SELECT CONCAT(regionname, '-' , address) AS full_address FROM melb LIMIT 5;

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 84 - DA0-001 discussion

Suggested answer: A

0 comments