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 are dml and ddl statements?

644


Is declare cursor executable?

607


What integrity rules exist in the dbms?

585


What is database development process?

523


Explain issues for database performance.

586






What do you understand by cursor?

564


How do I convert a spreadsheet to a database?

536


What are the types of database management system?

607


Where is database stored?

541


What is the difference between a database and a spreadsheet?

545


What is the difference between primary key and secondary key?

621


What is the e-r model?

555


What is father dbms?

967


What is database bloat?

564


Which is better saving files in database or in file system?

554