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

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 does clipper stand for?

520


Write down the differences between nosql and rdbms?

520


What are the four types of database?

488


What are the features of openedge features?

530


What the default privileges which get assigned ?

501






What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

460


Explain the difference between physical and logical data independence?

486


What is unique key in dbms?

473


What are the main differences between primary key and unique key?

500


Explain atomicity and aggregation?

569


Where is the data stored in a database?

488


What is procedure in database?

517


what are the different integrity rules present in the dbms?

496


What you mean by Object Relational DBMS?

534


What is record in a database?

466