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 t sql used for?

974

How do I run pl sql in sql developer?

1063

what are the differences between char and nchar? : Sql dba

1056

What is group function in sql?

966

What is procedure and function in sql?

930

What is the process of debugging?

1006

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2110

What is sql select statement?

971

what are ddl statements in mysql? : Sql dba

1114

What is the main difference between sql and pl/sql?

1028

how many ways to get the current time? : Sql dba

950

Why is pl sql used?

939

Is trigger a stored procedure?

887

What is a design view?

887

Explain mutating table error.

1132