|
|
|
|
| |
DB2 INTERVIEW QUESTIONS |
| No of Questions : 117 |
| Goto page Previous 1, 2, 3 ... 9, 10, 11, 12 Next |
|
| DB2 INTERVIEW QUESTIONS |
| SUM function |
Question : What is the result of this query if no rows are selected:
SELECT SUM(SALARY)
FROM EMP
WHERE QUAL=?MSC?;
|
|
View Answer(3)
|
|
| NULL value |
Question : Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?
|
|
View Answer(1)
|
|
|
|
|
|
|
