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
5923 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 "TABLE" datatype ?

2 Answers

What is the use of drop command and what are the differences between drop, truncate and delete commands?

0 Answers

What is a database in computer?

0 Answers

List few ways to code transactions in an efficient manner?

0 Answers

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

0 Answers

What is denormalization and why would someone consider doing so?

0 Answers

What is dba stand for?

0 Answers

What are the different types of database?

0 Answers

What is stored procedure in database?

0 Answers

What SYSTEM VARIABLE is used to refer DATABASE TIME ?

1 Answers

Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

0 Answers

What are the Different Types of Joins and How do They Work?

1 Answers

For more Database Management Interview Questions Click Here