Write a query to display the owner_name and contact_number of all building, Display the records in ascending order based on owner_name.

Question

Write a query to display the owner_name and contact_number of all building, Display the records in ascending order based on owner_name.
🧐 Not the exact question you are looking for?Go ask a question

Solution 1

Sure, here is a SQL query that will do that:

SELECT owner_name, contact_number 
FROM building 
ORDER BY owner_name ASC;

Here's a step-by-step breakdown of the query:

  1. SELECT owner_name, contact_number: This part of the query selects the data to be displayed. In this case, we want t Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solve study prob
Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solve study problem.
Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solve study problem.
Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solve study problem.
Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solv

This problem has been solved

Similar Questions

Write a query to display the owner_name and contact_number of all building, Display the records in ascending order based on owner_name.

Write a query to display all the building details in which building_type named ‘Library’. Display the records in ascending order based on their owner_name.

Write a query to display the name of all building types that ends with letter 'l'. Display the records in ascending order based on name

Write a query to display the name of all building types that ends with letter 'l'. Display the records in ascending order based on name.

Write a query to display all the contact number of the building_type named 'Police Station'. Display the records in ascending order based on the contact number

1/3