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
6280 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 natural key?

0 Answers

What are the characteristics of database?

0 Answers

What is data model example?

0 Answers

What is data sparsity and how it effect on aggregation?

0 Answers

Define RDBMS.

0 Answers Ernst Young, Thomson Reuters,

what is the use of EXP command ?

2 Answers

Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

0 Answers

What type of file is used for porting Forms 4.5 applications to various platforms?

1 Answers

What do you mean by super key, primary key, foreign key and candidate key?

0 Answers

How does a database partition work?

0 Answers

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

0 Answers Indian Web Technology,

Is a database a file?

0 Answers

For more Database Management Interview Questions Click Here