Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
- 13 Answers
- 19471 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nitinmukhraiya
Rownum and RowID displays the results faster than others -
select * from <Table_Name> where rownum=1
union
select * from (select * from <Table_Name> order by rownum desc) where rownum=1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is break?
In what condition is it good to disable a trigger?
What is indexes?
what is a table in a database ? : Sql dba
How do you pronounce sql?
Can you skip header records while loading? : aql loader
What is thread join () in threading?
What are schema-level triggers?
What is compound trigger?
What are the types of queries in sql?
Which one is faster ienumerable or iqueryable?
what is not null constraint? : Sql dba
What is rowid in sql?
what is a materialized view? : Sql dba
