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

how to escape special characters in sql statements? : Sql dba

1041

Can we join more than 2 tables in sql?

1027

What is a sql schema used for?

1110

What is the purpose of the sql select top clause?

1118

What do you mean by dbms? What are its different types?

1021

how to start mysql server? : Sql dba

1206

Is sql port 1433 encrypted?

1031

What is mdb stand for?

1015

what does the t-sql command ident_incr does? : Transact sql

1083

Mention what is the function that is used to transfer a pl/sql table log to a database table?

997

What is the best sql course?

989

What is rename in sql?

979

Can we update views in sql?

942

Is oracle and sql same?

1018

What are views in sql?

995