select min(sal) from (select sal from emp e1,emp e2 having e1.hiredate=e2

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

Question Posted / naresh

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

Please Help Members By Posting Answers For Below Questions

What is record in a database?

916

What is Schema in DBMS?

1120

Explain what is a deadlock and mention how it can be resolved?

932

What is dbms and its functions?

1056

Enlist the advantages of normalizing database.

1087

When does checkpoint occur?

930

What is raid controller technology?

1052

What is oracle block?

933

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

977

Explain the scenarios or situations under which progress database creates new index entry for a record?

1074

What is actional flow mapping?

999

Mention the differences between the clustered and non-clustered index

954

Explain the architecture of reporting services?

1033

What is the role of database management system?

983

What is entity relationship diagram?

978