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 sublanguage?

0 Answers  

Explain degree of a relation?

0 Answers  

If you need to refresh a website page every time a record is updated in database, how would you do it?

0 Answers   MindCracker,

What will the SHOW_ALERT function returns ?

3 Answers   College School Exams Tests, DSS,

Describe the difference between data and database administration.

0 Answers  




What is drivermanager getconnection?

0 Answers  

Describe reporting lifecycle?

0 Answers  

What is erd?

0 Answers  

Is filemaker pro a relational database?

0 Answers  

What is pcbs (program communication blocks)?

0 Answers  

What is the best database software?

0 Answers  

What are the steps in creating a database?

0 Answers  

For more Database Management Interview Questions Click Here
Categories