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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data sublanguage?

607


RDBMS file system can be defined as

632


Is it good to save image in database?

577


What is a system concept?

566


How to configure events with firewall?

614






Is mysql a rdbms?

589


what are the differences between an exclusive lock and a shared lock?

585


Enlist the various relationships of database.

703


What is 2nf in database?

571


What are the examples of database?

549


What is the maximum line size that dbms_output can handle?

666


What is dbms and its advantages?

590


How to find the size of database?

651


What are the two main functions of queries in databases?

960


Describe the difference between homogeneous and heterogeneous distributed database.

597