1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

determine the minimum salary of the employee and his details
who join on the same date

Question Posted / radhika

Answers were Sorted based on User's Feedback



determine the minimum salary of the employee and his details who join on the same date..

Answer / guest

do not quite understand the question -- mininum sal of the
employees who have the same join dates (partition by
hiredates), or the one employee with min sal.

Is This Answer Correct ?    1 Yes 0 No

determine the minimum salary of the employee and his details who join on the same date..

Answer / ns

select min(salary) from (select salary from employees where
hire_date = '21-JUN-99');

Is This Answer Correct ?    1 Yes 1 No

determine the minimum salary of the employee and his details who join on the same date..

Answer / naresh

select min(sal) from (select sal from emp e1,emp e2 having
e1.hiredate=e2.hiredate);

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Database Management Interview Questions

Name two utilities that oracle provides, which are use for backup and recovery.

0 Answers  

What is the difference between a database and a spreadsheet?

0 Answers  

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

0 Answers   Cap Gemini,

Describe and contrast sql and qbe.

0 Answers  

How can I join two tables in database?

0 Answers  




Mention the different types of cursor?

0 Answers  

What are the steps involved in Database Startup ?

2 Answers   247Customer,

Define fragmentation.

0 Answers  

what is difference between clustering and mirroring?

2 Answers   Religare,

select Nth highest salary by using rownum

4 Answers   Ford, TCS, Tech Mahindra,

When a form is invoked with CALL_FORM does Oracle forms issues?

1 Answers  

Difference between file system and relational database.

1 Answers  

For more Database Management Interview Questions Click Here
Categories