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 would you convert date into julian date format?

594

Is sql open source?

545

how to include numeric values in sql statements? : Sql dba

564

How do I edit a stored procedure?

557

What is a record in a database?

563

Is truncate ddl or dml?

545

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1530

What normalization means?

527

How to use boolean type in select statement?

585

What are reports usually used for?

568

How do I find duplicates in two columns?

556

What is the difference between stored procedure and view?

532

What are inbuilt functions in sql?

602

What are sql procedures?

584

Is sql a dbms?

536