Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?

April 26, 2017column employee employees list nullable project Table

0

Posted

Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?

1 Answer

0

Posted

SELECT EMPNO FROM EMP WHERE PROJECT IS NULL; 21.What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL=’MSC’; NULL