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
How to select a random record from a table?
What is a relation schema?
What are the functions of rdbms?
Define view, sequence and index in DBMS.
Describe the purposes and advantages stored procedure?
What is dbms and types of dbms?
What do you understand by database triggers?
What are database modules?
What does fill factor concept mean with respect to indexes?
What is procedure in dbms?
What is normalization and why it is used?
What is mean by dbms?
What is the purpose of a field in a database?
How rdbms is different from dbms?
How to do replication of firebird databases?