Write a query to display list of bus number,names, source and destination where source and destination of a bus is the destination and source of another bus. Display unique records in ascending order by bus_no.
Answers
Explanation:
I am writing SQL query to fetch the data.
Select bus_no, bus_names,bus_source,bus_destination
from bus_info
orderby bus_no
Here all the fields like bus_no, bus_names, bus_source, bus_destination are imaginary since the field names are not provided. And also table name is also assumed since the table names are not given.
"Select" will carry all the column which needs to be selected
"from clause" will carry the table name from which the data needs to be fetched
"orderby clause" sorts the data either in "ascending or descending order".
To Know More:
https://brainly.in/question/4661528
Write a sql query to get state-wise count of customers with ascending order of state
2. https://brainly.in/question/3510709
Write an sql query to find an employee whose salary is equal or greater than 10000.