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 |
What is the best free sql database?
How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
How do I use google cloud in sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How many LONG columns are allowed in a table?
What is primary key and foreign key?
How can you save or place your msg in a table?
types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.
What is nosql vs sql?
Can we update views in sql?
What is a database event trigger?
How do I view tables in sql developer?