nitin mukhraiya


{ City } bangalore
< Country > india
* Profession * informatica developer
User No # 111166
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 1
Questions / { nitin mukhraiya }
Questions Answers Category Views Company eMail




Answers / { nitin mukhraiya }

Question { IBM, 16000 }

Hi Everyone,
How to get fist and last record from a table in oracle?

Thanks in advance


Answer

Rownum and RowID displays the results faster than others -

select * from where rownum=1
union
select * from (select * from order by rownum desc) where rownum=1

Is This Answer Correct ?    0 Yes 1 No