Hello to All,
I have a query related to database as I want to display the rows of the table except last 2 rows? Can anyone from you guys help me to do so?
Please help me if you can?
Thanks in Advance
How to Display Rows of a Table Except Last Two Rows?
Comments
Sugandh |
| 24 Aug 2015 6:18 pm
select * from (select rownum r,emp.* from emp )
where r<=(select max(rownum)-&n from emp); this is for except of any no. of last rows.
Abhijeet Mudgal |
| 24 Aug 2015 6:18 pm
Select * from emp where rownum <=(( select count(*) from emp) -2)
Sushma |
| 24 Aug 2015 6:19 pm
Thanks for the replies.
Next Story
Tutorials
- Oracle Overview
- Oracle Training Course
- Oracle Interview Questions
- Difference Between Oracle 11g and 12c and 10g
- Ora 28001 The Password Has Expired Error
- BR*Tools Documentation
- Oracle Wait Events Interview Questions
- Difference Between Primary, Secondary and Clustered Indexes in DBMS
- Difference Between Hot and Cold Backup
- Oracle Partitioning Interview Questions
- Update Statement Works in Oracle Architecture
- Differences Between SAP HANA and Oracle
Get solutions from our experts!
You need to select * from emp where rowid <(select max(rowid) from emp where rowid <>(select max(rowid) from emp) ); ---->this is my view.