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

What is data sparsity and how it effect on aggregation?

0 Answers  

How to implement a database management system?

0 Answers  

Why do not you use gnu autoconf or scons for building?

0 Answers  

How do you pass values from one form to another form ?

1 Answers  

Which database is faster?

0 Answers  




How index hunting contributes in improving the query performance?

0 Answers  

What is data management process?

0 Answers  

What is database management definition?

0 Answers  

wat is meant by oracle

3 Answers   Infosys,

What is the use of CONSTRAINTS option in EXP command ?

1 Answers  

How to configure events with firewall?

0 Answers  

What is atomicity in dbms?

0 Answers  

For more Database Management Interview Questions Click Here
Categories