Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
Answer Posted / cbigmudre
(select * from table limit 0,1)
union
(select * from table order by Id desc limit 0,1)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Can you join views in sql?
What is sql in oracle?
Explain table and field in sql?
How are sql commands classified?
Is pl sql useful?
Can we perform dml on view?
how to shutdown mysql server? : Sql dba
What are the different ways to optimize a sql query?
What are the features of pl sql?
What is an emotional trigger?
Explain the difference between drop and truncate commands in sql?
Is it possible to update views?
describe transaction-safe table types in mysql : sql dba
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
what is a table in a database ? : Sql dba