SQL>SELECT ENAME,SAL FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP);

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

Question Posted / amit

10 Answers
15157 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / amit

SQL>SELECT ENAME,SAL FROM EMP
WHERE SAL>(SELECT AVG(SAL) FROM EMP);

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between left join and right join?

938

What is difference between db2 and sql?

996

Why we use sql profiler?

950

Does sql support programming?

1064

What are different functions in sql?

938

How would you reference column values before and after you have inserted and deleted triggers?

1063

What are the parts of a sql statement?

1082

Explain some predefined exceptions.

1027

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1034

How can we implement rollback or commit statement in a trigger?

1026

List the various privileges that a user can grant to another user?

1036

How many disk partitions should I have?

982

Is primary key is clustered index?

996

Is hadoop a nosql?

994

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4269