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 avg(Isnull(salary,10000)) 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...
- Employee table has salary field in this case if we give the query : select * from employee where sal<2000 a...
- In oracle,what is the output of given query if the value of salary is '25000'?
- Employee table has salary field in this case if we give the query : select * from employee where sal<2000 a...
- Click the Exhibit button and examine the data in the EMPLOYEES table. Which three sub queries work? (Choose...
- Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will s...
- Select * from employees where (total_sales-25000) between (select avg(total_sales) from employees) and (sel...
- Employee table : Emp_No Emp_Name Salary 101 Emp1 10000 102 Emp2 80000 103 Emp3 50000 Employee is the source...