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(salary) 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...
- Click the Exhibit button and examine the data in the EMPLOYEES table. Which three sub queries work? (Choose...
- Employee table has salary field in this case if we give the query : select * from employee where sal<2000 a...
- 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'?
- The employee information in a company is stored in the relation Employee (name, sex, salary, deptName) Cons...
- Create table employee salary (empid int, fname varchar (30), lname varchar (30), dept varchar (30), salary ...
- There is a table called Employee having columns are empno, ename , job , deptno,grade and salary. Which of ...