A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Null 4 ddd Null 35000 select count(deptno) from employee?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Nu...
- A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Nu...
- Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will s...
- SELECT department, COUNT(1) FROM employees WHERE salary > 25000 GROUP BY department; What about this query ...
- SELECT name,salary , dept FROM emp e WHERE NOT EXISTS (SELECT 1 FROM dept WHERE deptno = e.dept); Which emp...
- What will be the output of the following query? select count(*) from employees e1, e2, department d where e...
- SELECT address1||','||address2||','||address2 "Adress" FROM employee;
- Consider the relation schema as follows. Employee (employee-name, sheet, city) Works (employee-name, compan...