write an SQL query to fetch " First_NAME" from worker table using the alias name as<WORKER_NAME>
Answers
Answered by
21
Answer:
SELECT FIRST_NAME AS "EMPLOYEE NAME" FROM EMPLOYEES;
Answered by
8
"SQL Query: Select FIRST_NAME AS WORKER_NAME from Worker".
Explanation :
Select FIRST_NAME AS WORKER_NAME from Worker.
The SELECT statement returns a set of records, from one or more tables.
The FIRST_NAME is the column name given in the table.
The WORKER_NAME is the column name that we are going to change from FIRST_NAME.
The from refers to the table where the data are going to retrieve.
The worker is the table name, that the data is retrieved from.
Similar questions