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
15246 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

More SQL PLSQL Interview Questions

what does it mean to have quoted_identifier on? : Sql dba

0 Answers

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers TCS,

What are the different types of tables in sql?

0 Answers

How do u count no of rows in a table?

8 Answers CTS,

What is the command used to fetch first 5 characters of the string?

0 Answers

What is pl/sql table? Why is it used?

0 Answers

How to run sql statements with oracle sql developer?

0 Answers

How do I add a primary key to a table?