query to retrive the employees whose sal is greater than avg
sal
Answers were Sorted based on User's Feedback
Answer / gop
SELECT sal FROM EMPLOYEES WHERE sal>(SELECT avg(sal) FROM
EMPLOYEES);
Is This Answer Correct ? | 47 Yes | 6 No |
Answer / shiva
select e.* from emp e where e.sal>(select avg(sal) from emp);
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / gourav
select salary,AVG_SALARY from z1
where salary>AVG_SALARY
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / swapna
select ename from emp where sal>(select avg(sal) from emp);
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / damy
select salary from table_name where salary >=(select avg(salary) from table_name)
Is This Answer Correct ? | 3 Yes | 1 No |
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 |
Answer / amit
SQL>SELECT ENAME,SAL FROM EMP
WHERE SAL>(SELECT AVG(SAL) FROM EMP);
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / swastik
SELECT Sal
FROM Emp
WHERE Sal >
(
SELECT AVG(Sal)
FROM Emp
);
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
How many types of database triggers can be specified on a table ? What are they ?
What are the ways on commenting in a pl/sql code?
What are different types of functions in sql?
Why do we use procedures in pl sql?
Write a query to display the current date in sql?
How do I save a stored procedure?
in procedure how to return a value
Why are indexes and views important to an organization?
How would you convert date into julian date format?
How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }
How to find only %th Highest Sal
What is mutating table?