query to retrive the employees whose sal is greater than avg sal

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

query to retrive the employees whose sal is greater than avg
sal

Question Posted / teja

10 Answers
13605 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

query to retrive the employees whose sal is greater than avg sal..

Answer / gop

SELECT sal FROM EMPLOYEES WHERE sal>(SELECT avg(sal) FROM
EMPLOYEES);

Is This Answer Correct ?

47 Yes

6 No

query to retrive the employees whose sal is greater than avg sal..

Answer / shiva

select e.* from emp e where e.sal>(select avg(sal) from emp);

Is This Answer Correct ?

6 Yes

3 No

query to retrive the employees whose sal is greater than avg sal..

Answer / gourav

select salary,AVG_SALARY from z1
where salary>AVG_SALARY

Is This Answer Correct ?

4 Yes

1 No

query to retrive the employees whose sal is greater than avg sal..

Answer / swapna

select ename from emp where sal>(select avg(sal) from emp);

Is This Answer Correct ?

4 Yes

2 No

query to retrive the employees whose sal is greater than avg sal..

Answer / damy

select salary from table_name where salary >=(select avg(salary) from table_name)

Is This Answer Correct ?

3 Yes

1 No

query to retrive the employees whose sal is greater than avg sal..

Answer / badchip

select ename,esal from emp_mast where esal > (select avg
(esal) from emp_mast group by esal);

Is This Answer Correct ?

3 Yes

2 No

query to retrive the employees whose sal is greater than avg sal..

Answer / amit

SQL>SELECT ENAME,SAL FROM EMP
WHERE SAL>(SELECT AVG(SAL) FROM EMP);

Is This Answer Correct ?

3 Yes

3 No

query to retrive the employees whose sal is greater than avg sal..

Answer / swastik

SELECT Sal
FROM Emp
WHERE Sal >
(
SELECT AVG(Sal)
FROM Emp
);

Is This Answer Correct ?

0 Yes

0 No

query to retrive the employees whose sal is greater than avg sal..

Answer / musthafa

SELECT EMP_NO,EMP_SAL
FROM EMP_TAB
WHERE EMP_NO=&EMP_NUM
GROUP BY EMP_NO
HAVING EMP_SAL > AVG(EMP_SAL)

Is This Answer Correct ?

0 Yes

1 No

query to retrive the employees whose sal is greater than avg sal..

Answer / viren

since we are using aggregate function AVG, we have to use
GROUP BY, HAVING clause.

select empName, avg(sal) from employees group by sal having
sal > avg(sal) order by empName;

Is This Answer Correct ?

4 Yes

12 No

Post New Answer