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

How to select a random record from a table?

935

What is a relation schema?

964

What are the functions of rdbms?

970

Define view, sequence and index in DBMS.

909

Describe the purposes and advantages stored procedure?

981

What is dbms and types of dbms?

1054

What do you understand by database triggers?

917

What are database modules?

903

What does fill factor concept mean with respect to indexes?

914

What is procedure in dbms?

864

What is normalization and why it is used?

1104

What is mean by dbms?

999

What is the purpose of a field in a database?

941

How rdbms is different from dbms?

890

How to do replication of firebird databases?

927