SELECT *FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP WHERE DEPTNO=10);

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department.
Write a query

Question Posted / sri

7 Answers
12432 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / sri

SELECT *FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP WHERE
DEPTNO=10);

Is This Answer Correct ?

4 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1036

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

992

What happens when a session fails and you click on recover?

1065

How to partition the Session?

1044

What is the difference between source qualifier transformations source filter to filter transformation?

998

How you can differentiate between connected lookup and unconnected lookup?

1009

Write the unconnected lookup syntax and how to return more than one column.

1051

Explain the different dimensions.

917

Repository user profiles

1715

Explain scd type 3 through mapping.

918

Which files are created during the session rums by informatics server?

1124

What could be the possible resons of locks by user?

1036

generate date / time dimension in informatica

1073

Is it possible to define a single node as a Gateway node as well as worker node?

1059

Briefly describe lookup transformation?

982