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
Can cursors be part of a trigger body?
How do I partition a table in sql?
How do you delete a table?
What are the different operators available in sql?
What is mutating sql table?
When is a declare statement required?
How do I create a sql database?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Define the select into statement.
What is difference sql and mysql?
Can we use having without group by in sql?
What are primary key and foreign key and how they work?
Is postgresql a nosql database?
What is trigger and how to use it in sql?
What is the current version of sql?