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

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

Question Posted / radhika

3 Answers
6275 Views
I also Faced
E-Mail Answers

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 tabular form?

0 Answers

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?

3 Answers eBay,

Do models have limitations?

0 Answers

What are database modules?

0 Answers

what do u mean by canvases and alerts?

0 Answers

What is buffer manager?

0 Answers

How do convert or display the date or time as string?

0 Answers

what is the location of oracle inventory?