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
- 12920 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
Explain the difference between a data warehouse and a data mart?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the command used to run a batch?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Can you use flat files in Mapplets.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can we use mapping variables in informatica?
can anyone explain me about retail domain project in informatica?
What is complex mapping?
Explain the difference between mapping parameter and mapping variable?
What is rank transform?
What is the need for an etl tool?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
