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

3 Answers
6274 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What versions of clipper does netlib support?

1057

Explain about cursors?

1168

What are the components of rdbms?

983

What is a relation in dbms?

1236

How many types of database language exist?

1104

Suppose database is running slow, what will you do?

2568

How many number of columns can a RECORD GROUP have ?

2069

Can you explain insert, update and delete query?

1097

Why dbms is used?

978

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

1054

Is sql is a dbms?

961

What are the types of database servers?

1046

i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.

1884

What are different types of joins in the sql?

1050

What do you understand by data independence? What are its two types?

1115