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

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1045

What is difference between group by and partition by?

978

What is mutating error in pl sql?

965

How can you fetch common records from two tables?

1004

What is embedded sql what are its advantages?

962

what happens if null values are involved in expressions? : Sql dba

1001

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

951

What type of database is sql?

979

What is the difference between join and natural join?

883

What are synonyms in sql?

932

What are different types of statements supported by sql?

1099

Does sql between include endpoints?

955

What is the purpose of design view?

952

What is the difference between microsoft access and sql?

961

How does join work in sql?

962