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
Related
- Smartforms Template Shading a Row
Hi All, Could anyone please tell me how to color/shade a row in a template. I have created a template in a window. I have some rows and columns in my template. I want to shade some... - How to Increase a row height in Table control
Hi we need to increase the row height for one of the table displays. is it possible to do by GUIXT thanks - How Many Rows will be Return from Two Tables?
Hello SAP Experts,I have a query if anyone from you guys can solve it then please go ahead and try to solve my below given query:I have 2 tables A and B. A table having 4 rows and B table having 2... - Customer1 Row should be Empty and Second Row having Data.
Dear Experts, I am Facing one issue in BI Report. I have a report on General outstanding in this report customer having two keys but the output shows as below: Customer1: xxxxx xxxxxx xxxxx...
Forums
Books
Jobs
-
SAP BI | 4-6 yrs | Bangalore | Atlas System
Exp :4 - 6 years | City : Bangalore -
SAP Basis Consultant | 6 - 8 yrs | Bangalore | Sony India
Exp :6 - 8 years | City : Bangalore -
Opening for Sr. SAP Basis Consultant @ Bangalore (Immediate
Exp :6 - 15 years | City : Bangalore -
SAP with Portuguese & English Langauge Support | 3 - 6 Years
Exp :3 - 6 years | City : Hyderabad -
Solution Architect for the Oracle Hyperion EPM Suite | 8 - 1
Exp :8 - 13 years | City : Bangalore
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.