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
Why is sql important?
What plvcmt and plvrb does in pl/sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How do I add a database to sql?
Explain some predefined exceptions.
what are date and time data types? : Sql dba
What is sql and its types?
How is use pl and sql?
What is the difference between function and procedure in pl/sql?
what is foreign key? : Sql dba
What if we write return in procedure?
How do I edit a trigger in sql developer?
What is full join?
When can we use the where clause and the having clause?
What do you mean by stored procedures? How do we use it?