select ename from emp where sal>(select avg(sal) from emp);

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

Question Posted / swapna

Answer Posted / swapna

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is difference between group by and partition by?

1006

How do you take the union of two tables in sql?

959

What is sql not null constraint?

996

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2543

Is primary key always clustered index?

965

What is query optimization in sql?

952

Can %notfound return null after a fetch?

1024

what are the type of locks ? : Sql dba

922

What are the advantages of sql? Explain

1069

What does pragma mean?

998

What is a pl/sql block?

1146

What are the types of join and explain each?

1004

What is sharding in sql?

937

How do I find duplicates in two columns?

1095

How many triggers can be applied to a table?

1019