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
- 10515 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
explain about unit testing? in real time?
How can one identify whether mapping is correct or not without connecting session?
How are the sources and targets definitions imported in informatica designer?
Write the different tools in the workflow manager?
Write the prerequisite tasks to achieve the session partition?
Explain the tuning lookup transformation - informatica
differences between service based and product based?
Define joiner transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Differentiate between a database and data warehouse?
What is informatica powercenter repository?
What is the need of etl tools?
What is a stored procedure transformation?
Where is metadata stored?
