Question

Write An SQL Query To Print All Worker Details From The Worker Table Order By FIRST_NAME Ascending.​

Answer 1

Answer:

SELECT * FROM Worker ORDER BY FIRST_NAME ASC

Explanation:

table_name: name of the table.

column_name: name of the column according to which the data is needed to be arranged.

ASC: to sort the data in ascending order.

Answer 2

MySQL query to print all worker details from the worker table order by FIRST_NAME ascending is

SELECT * FROM Worker ORDER BY FIRST_NAME ASC;

• Here ORDER BY is used to sort the FIRST_NAME column in ascending order. ASC represents ascending order. For descending order we can use DESC.
• SELECT * represents selecting and displaying all the details of worker.

#SPJ3