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
- 7 Answers
- 10563 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vivek singh
SELECT * FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP)
AND DEPTNO=10;
O/P:
7839 KING PRESIDENT 17-NOV-81 5000 10
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the informatica performance improvement tips
What is main use of mapplet?
list out all the transformations which use cache?
What is option by which we can run all the sessions in a batch simultaneously?
explain about unit testing? in real time?
Explain sql transformation in script mode examples in informatica
what is the hint? how to use it to reduce the query processing in program?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the tasks that can be performed using sq?
how to create user defined function (udf) in informatica
How can we use batches?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is union transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
