Which of the following is the proper way to create an alias, E, for relational table Employee and retrieve all employee data? O A SELECT * AS E FROM EMPLOYEE; OB. SELECT * FROM EMPLOYEE WHERE EMPLOYEE = E; OC. SELECT * FROM EMPLOYEE E; OD. SELECT E.* FROM EMPLOYEE;
Which of the following is the proper way to create an alias, E, for relational table Employee and retrieve all employee data? O A SELECT * AS E FROM EMPLOYEE; OB. SELECT * FROM EMPLOYEE WHERE EMPLOYEE = E; OC. SELECT * FROM EMPLOYEE E; OD. SELECT E.* FROM EMPLOYEE;
Related questions
Question

Transcribed Image Text:**Question:**
Which of the following is the proper way to create an alias, E, for relational table Employee and retrieve all employee data?
**Options:**
A. `SELECT * AS E FROM EMPLOYEE;`
B. `SELECT * FROM EMPLOYEE WHERE EMPLOYEE = E;`
C. `SELECT * FROM EMPLOYEE E;`
D. `SELECT E * FROM EMPLOYEE;`
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
