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 triggers are there in pl sql?
Is oracle sql free?
Why do we use view in sql?
How will you delete a particular row from a Table?
What is sql entity?
What is the difference between unique and primary key constraints?
how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
what is the difference between union and union all? : Sql dba
How to get second highest salary from a table
suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary
Why do we need databases?