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

What is the difference between left outer join and left join?

1033

What are the various levels of constraints?

1167

what are ddl statements in mysql? : Sql dba

1258

What are the subsets of sql?

1192

Can a key be both primary and foreign?

1050

What is sqlexception in java?

1033

Is sqlite free?

1020

What are the main features of cursor?

1108

What is a database trigger?

1127

Define implicit and explicit cursors.

1203

What is sql catalog?

1065

Explain the difference between 'between' & 'and' operators in sql

1038

What is t-sql? : Transact sql

1036

what is the difference between clustered and non clustered index in sql? : Sql dba

1182

What is break?

1248