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
5997 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

Explain the syntax of named procedure?

0 Answers

What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?

0 Answers

What are the database objects?

0 Answers

Define database system.

0 Answers

Define truncate and delete commands?

0 Answers

What are the different types of modeling?

0 Answers

From where the Transactions per rollback segment is derived ?

1 Answers

How can we tune a oracle database if log file sync issue comes

0 Answers L&T,

What is different keys in dbms?

0 Answers

What are the basic elements of Base configuration of an oracle Database ?

1 Answers

What do you understand by join?

0 Answers

What is 2-tier architecture?

0 Answers

For more Database Management Interview Questions Click Here