query to retrive the employees whose sal is greater than avg
sal
Answer Posted / shiva
select e.* from emp e where e.sal>(select avg(sal) from emp);
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
what is text? : Sql dba
How to add new employee details in an employee_details table with the following details
Can a foreign key be null?
Why are aggregate functions called so?
What is vector point function?
what are the different functions in sorting an array? : Sql dba
What is oracle and pl sql?
Which is better join or subquery?
How we can update the view?
What is duration in sql profiler trace?
What is the difference between an inner join and an outer join?
Why join is faster than subquery?
What is varray in pl sql?
what is user defined functions? : Sql dba
how are mysql timestamps seen to a user? : Sql dba