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

how to extract a unit value from a date and time? : Sql dba

550

How many aggregate functions are available there in sql?

523

when MSQL8.0 is in market

1592

Can you have more than one key in a database?

503

Explain the advantages and disadvantages of stored procedure?

640

Can you sum a count in sql?

550

What is query optimization in sql?

544

Is keyword pl sql?

555

What is trigger and how to use it in sql?

529

What is mdb stand for?

550

what is the difference between where clause and having clause? : Sql dba

529

what is sql profiler? : Sql dba

580

What are % type and % rowtype?

568

how to dump a table to a file with 'mysqldump'? : Sql dba

543

What is the primary use of normalization?

520