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
Why do not you use gnu autoconf or scons for building?
What do you understand by fragmentation?
How can you get the alternate records from the table in the sql?
Explain dml compiler?
Explain what is a deadlock and mention how it can be resolved?
What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?
What is 3nf in the dbms?
What is rdbms and its features?
What are the disadvantages of file processing systems?
What is delimiter in dbms?
what do u mean by canvases and alerts?
What are the drawback of rdbms?
how to retrive a data From database into the grid view..?
Differentiate nested loop, hash join and merge join.
Can we save file in database?