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
How does a self join work?
Is ms sql is free?
What is on delete set null?
what is top in tsql? : Transact sql
What is sql data?
What is the use of function "module procedure" in pl/sql?
What is example of database?
What is the difference between join and natural join?
What is the size of partition table?
How can we optimize a sql query?
What is a database? Explain
Why is sql better than hql?
how can we know the number of days between two given dates using mysql? : Sql dba
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
How do I order columns in sql?