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

Why is it better to use an Integrity Constraint to validate data ?

1 Answers

What is Database testing and What are ways of writing test cases for database testing?

0 Answers Ittiam Systems,

How to disconnect the user connection?

0 Answers

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

0 Answers L&T,

What is end users in dbms?

0 Answers

Is declare cursor executable?

0 Answers

What is the difference between a delete command and truncate command?

0 Answers

What are the types of database users?

0 Answers

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

0 Answers eBay,

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

1 Answers

What are the different stages in 'data warehousing'?

0 Answers

Explain what are super servers?

0 Answers

For more Database Management Interview Questions Click Here