select empno,ename,sal from emp group by rownum,empno,ename,sal having ro

display records from 5 to 9 using rowid or rownum

Question Posted / satya

Answer Posted / satya

select empno,ename,sal from emp
group by rownum,empno,ename,sal
having rownum between 5 and 9;

Is This Answer Correct ?

2 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Can cursors be part of a trigger body?

1694

How do I partition a table in sql?

1209

How do you delete a table?

1124

What are the different operators available in sql?

1059

What is mutating sql table?

1160

When is a declare statement required?

1197

How do I create a sql database?

1056

how many sql ddl commands are supported by 'mysql'? : Sql dba

1067

Define the select into statement.

1112

What is difference sql and mysql?

1038

Can we use having without group by in sql?

1052

What are primary key and foreign key and how they work?

1020

Is postgresql a nosql database?

1229

What is trigger and how to use it in sql?

1070

What is the current version of sql?

1070