Answer Posted / bindu
select * from (select rownum r1,e.* from emp e)
where r1=2;
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
Can we use loop in sql?
explain the difference between delete , truncate and drop commands? : Sql dba
How can you load multi line records? : aql loader
How to change the order of columns in Oracle SQL Plus ?
What is sqlite used for?
how to fetch alternate records from a table? : Sql dba
what is heap table? : Sql dba
What is meant by cursor in sql?
Which operator is used in query for pattern matching?
Which one is better sql or oracle?
What is the non-clustered index in sql?
What is consistency?
What is sql stand for?
What are some predefined exceptions in pl/sql?
What is gpt format?
