Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
Answer Posted / ataullah
Select * from emp where rowid=(select max(rowid) from emp) or rowid=(select min(rowid) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to order siblings in oracle hierarchy queries?
What is function and procedure in pl sql?
Show how functions and procedures are called in a pl/sql block.
What is nvl?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is the difference between Union and Union all. Which is faster.
Is record in pl sql?
What is composite data type in pl sql?
How can I tell if sql is running?
What is informix sql?
how many tables will create when we create table, what are they? : Sql dba
Explain correlated query work?
What is data type in database?
What is cartesian join in sql?
what is the difference between $message and $$message? : Sql dba