select min(salary) from (select salary from employees where hire

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

Question Posted / ns

Answer Posted / ns

select min(salary) from (select salary from employees where
hire_date = '21-JUN-99');

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the basic functions of a database?

939

How do you rename a database?

845

What is acid property in dbms?

906

How to specify transaction or query timeout?

972

What is n tier architecture in dbms?

872

What is data management process?

889

Where is data stored in database?

829

Describe the types of keys?

1027

What is meant by database system?

858

Define "correlated subqueries".

875

Explain primary key and composite key.

924

What is the purpose of a field in a database?

873

Explain the different types of join operations?

971

Could you give me an example how, where I code checkpoint and restart. I need and example

925

What do you mean by dml compiler?

999