Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the types of dbms?
what is 'mysqldump'? : Sql dba
tell us something about heap tables. : Sql dba
What are triggers in sql?
Show how functions and procedures are called in a pl/sql block.
Enlist some predefined exceptions?
Explain what is a column in a table?
What is the difference between sum and count in sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How delete all records from table in sql?
What is the difference between local variables and global variables?
describe transaction-safe table types in mysql : sql dba
Explain the the delete statements in sql?
