display records from 5 to 9 using rowid or rownum
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
What is the difference between left outer join and left join?
What are the various levels of constraints?
what are ddl statements in mysql? : Sql dba
What are the subsets of sql?
Can a key be both primary and foreign?
What is sqlexception in java?
Is sqlite free?
What are the main features of cursor?
What is a database trigger?
Define implicit and explicit cursors.
What is sql catalog?
Explain the difference between 'between' & 'and' operators in sql
What is t-sql? : Transact sql
what is the difference between clustered and non clustered index in sql? : Sql dba
What is break?