determine the minimum salary of the employee and his details
who join on the same date
- 3 Answers
- 4754 Views
- I also Faced
- E-Mail Answers
Answer Posted / naresh
select min(sal) from (select sal from emp e1,emp e2 having
e1.hiredate=e2.hiredate);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is data types in database?
Compare non-clustered and clustered index
What are the applications of database?
What is rdbms table?
What do you mean by DBMS?
What is 2nf in the dbms?
What is rdbms and its features?
Why normalisation is required?
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
How do I delete a database in phpmyadmin?
What do you mean by e-r model?
Is database a storage?
What is concept of dbms?
Explain Relational Algebra in RDBMS
What is the advantages and disadvantages of database management system?
