CBSE Class 12 Informatics Practices
Question 80 of 81
MySQL Functions — Question 10
Back to all questions 10
Question Write a query against the ADDRESS table to show the names (first name, last name) and phones of all persons concatenated in following form :
TinaSeth23456789
MoradK.22211890
Table ADDRESS ( contains following eight columns)
LastName VARCHAR(25),
FirstName VARCHAR(25),
Street VARCHAR(50),
City VARCHAR(25)
State CHAR(2),
Zip NUMBER,
Phone VARCHAR(12),
Ext VARCHAR(5)
SELECT CONCAT(FIRSTNAME, LASTNAME, PHONE)
FROM ADDRESS;