select empno,ename,sal,comm,job,mgr,deptno from emp group by empno,ename,s

how to retrive only second row from table?

Question Posted / kishan kumar

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

Please Help Members By Posting Answers For Below Questions

What is rank () in sql?

934

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1039

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1010

How can we debug in PL/SQL?

1131

What is the difference between a primary key and a clustered index?

986

Show the cursor attributes of pl/sql.

1046

Is microsoft sql free?

1095

What are different types of statements supported by sql?

1165

What is a primary key? Explain

972

Can we create index on primary key?

962

What is trigger types of trigger?

1066

Why is the cursor important?

1038

What is dml and ddl?

951

What is a full join?

972

Is ms sql is free?

1020