Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
Answer Posted / ramesh
Select * from table_name where rowid =(select min(rowid)
from tanle_name)
union
select * from table_name where rowid = (select max(rowid0
from table_name);
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Why stored procedure is faster than query?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Differentiate between % rowtype and type record.
how to rename an existing column in a table? : Sql dba
Should I use mbr or gpt?
Can I call a procedure inside a function?
When to use inner join and left join?
is mysql query is case sensitive? : Sql dba
what is recursive stored procedure? : Sql dba
What is synchronized subquery?
What is sql prepared statement?
define sql update statement ? : Sql dba
What is delimiter in pl sql?
What is difference between cursor and trigger?
What is before trigger?