Answer Posted / kishan kumar
select empno,ename,sal,comm,job,mgr,deptno from emp
group by empno,ename,sal,comm,mgr,deptno,rownum
having rownum in (2);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is Collation Sensitivity ? What are the various type ?
Is vs as in pl sql?
What is informix sql?
How to add, remove, modify users using sql?
What type of database is cloud sql?
Why do we need unique key in a table?
How do you explain an index number?
What is ttitle and btitle?
what is uncommittable transactions? : Transact sql
How do I view stored procedures?
How do I pipe the output of one isql to another?
what are the differences among rownum, rank and dense_rank? : Sql dba
Why do we need a foreign key?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How much does sql certification cost?
