determine the minimum salary of the employee and his details
who join on the same date
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 unique key example?
Mention the different languages present in dbms
How index hunting contributes in improving the query performance?
describe middleware applications that ease the connection of databases to web?
What is the main purpose of normalization?
Explain the syntax of named procedure?
Explain environment of openedge?
What do you mean by aggregate and scalar functions in dbms?
What is a foreign key constraint?
What do you understand by the terms entity, entity type, and entity set in dbms?
Explain what are super servers?
What is the purpose of database?
How do we select distinct values from a table?
What is database schema in dbms?
How big is google's database?