“SELECT * FROM employee WHERE salary>10000 AND dept_id=101;
Which of the following fields are displayed as output?”

SELECT * FROM employee WHERE salary>10000 AND dept_id=101;
Which of the following fields are displayed as output?
All the field of employee relation
Explanation: Here * is used to select all the fields of the relation.
Salary, dept_id
Employee
Salary

Leave a Reply

Your email address will not be published. Required fields are marked *