Question

Write a query to display address details by concatenating address and city of students . Give an alias as Address and sort the result based on the concatenated column in descending order

Answer 1

Answer:

select (address || ',' || city) as Address from student order by address desc;

Explanation:

Answer 2

Answer:

The query is as:

Select (address || ',' || city) as Address from Student

Order by Address DESC;

Explanation:

The required query as per the question is as:

Select (address || ',' || city) as Address from Student

Order by Address DESC;

The above written query will give the desired result by fetching the associated rows.

Hence, this is the required answer.