select e.* from emp e where e.sal>(select avg(sal) from emp);

query to retrive the employees whose sal is greater than avg
sal

Question Posted / shiva

Answer Posted / shiva

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can a table have no primary key?

1011

What is cursor in pl sql?

1052

Which sorts rows in sql?

970

How do you add a column to a table?

997

What is the use of partition by in sql?

931

What are commit, rollback, and savepoint?

940

What are the set operators in sql?

1032

How many commands are there in sql?

973

how to get help information from the server? : Sql dba

878

How do you update a table in sql?

930

How many types of primary keys are there?

980

Does group by remove duplicates?

983

what is union? : Sql dba

968

Write a sql query to get the third highest salary of an employee from employee_table?

1030

What is null in pl/sql?

1023