Assuming you are using SQL, the query would look something like this:

```sql
SELECT owner_name, CONCAT(contact_number, '-', email) AS contact_details
FROM your_table_name
ORDER BY owner_name DESC;
```

Please replace `your_table_name` with the actual name of your table. This query will select the `owner_name` and concatenate `contact_number` and `email` with a hyphen in between. The `AS` keyword is used to assign an alias `contact_details` to the concatenated field. The `ORDER BY` clause is used to sort the records in descending order based on `owner_name`.

Question

Assuming you are using SQL, the query would look something like this:

```sql
SELECT owner_name, CONCAT(contact_number, '-', email) AS contact_details
FROM your_table_name
ORDER BY owner_name DESC;
```

Please replace `your_table_name` with the actual name of your table. This query will select the `owner_name` and concatenate `contact_number` and `email` with a hyphen in between. The `AS` keyword is used to assign an alias `contact_details` to the concatenated field. The `ORDER BY` clause is used to sort the records in descending order based on `owner_name`.

Knowee AI · Accepted Answer

Assuming you are using SQL, the query would look something like this:

```sql
SELECT owner_name, CONCAT(contact_number, '-', email) AS contact_details
FROM your_table_name
ORDER BY owner_name DESC;
```

Please replace `your_table_name` with the actual name of your table. This query will select the `owner_name` and concatenate `contact_number` and `email` with a hyphen in between. The `AS` keyword is used to assign an alias `contact_details` to the concatenated field. The `ORDER BY` clause is used to sort the records in descending order based on `owner_name`.

Write a query to display all the owner_name and concatenate contact_number and email with a hyphen(-) separated . Display the records in descending order based on owner_name . Give an alias name as 'contact_details'.

Question

Solution

Similar Questions

Upgrade your grade with Knowee