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

5 Answers
16060 Views
Agile Software, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does an inner join do?

1192

Explain the types of joins in sql?

1036

Is postgresql a nosql database?

1166

What is example of database?

1062

What is a loop in sql?

990

What is normalisation and its types?

1012

What is the difference between union and union all command?

1096

What does pl sql stand for?

1121

Is sql injection illegal?

1030

How do I restart sql?

979

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1029

What is $$ in sql?

998

Does a primary key have to be a number?

968

how can you create an empty table from an existing table? : Sql dba

1158

What language is oracle sql developer?

1024