Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12729 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
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 is domain and gateway node?
What is the function of aggregator transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is meant by lookup transformation? Explain the types of lookup transformation?
Define Pmrep command?
Briefly explain the aggregator transformation?
Differentiate between a database and data warehouse?
What is joiner change?
What are the various types of transformation?
What is an active transformation?
How do we call shell scripts from informatica?
Why update strategy and union transformations are active?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
