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

how many groups of data types? : Sql dba

1000

How to run sql statements with oracle sql developer?

1046

How do I edit a trigger in sql developer?

969

What are the most important characteristics of pl/sql?

1134

How to select unique records from a table?

1037

What is pl sql quora?

1125

What is trigger in sql?

1065

What is indexing in sql and its types?

1055

What are the 3 modes of parameter?

1144

What are triggers in sql?

1004

what is the use of double ampersand (&&) in sql queries?

1156

Differentiate between sga and pga.

1142

What is normalization sql?

1036

What is sql and its types?

1154

What is vector point function?

1026