Question

Write a query to display to concatenate student's first name and last name, give alias name as STUDENTNAME. Sort result in ascending.

Answer 1

Answer:

select concat (first_name, ' ', last_name) as student_name

from student

order by student_name;

Answer 2

Answer: select firstname||' ' ||lastname as STUDENTNAME

from student

order by STUDENTNAME asc;

Explanation: I have used pipeline method to concatenate the names and sorted by the new name created.