Custom Search
How to fetch last n rows only in DB2?
Fri, 07/29/2011 - 13:02
I Know there is a command in SQL to fetch first n rows only
For example:-
SELECT Employee_no, Salary FROM Employee-table
WHERE Salary > 10000
FETCH FIRST 10 ROWS ONLY
The above query will fetch first 10 rows from Employee-table
But if I have to fetch last 10 rows from a table, I tried using
"FETCH LAST 10 ROWS only"
But this command gave me error
SQLCODE = -104, ERROR: ILLEGAL SYMBOL "LAST". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: FIRST
";
;
;
;
Thu, 09/08/2011 - 10:21
#1
How to fetch last n rows only in DB2?
You can use ORDER BY clause ... the syntax is as below
SELECT COL_A
FROM YOUR.TABLE
WHERE KEY_A = :KEY-A
ORDER BY COL_A DESC
FETCH FIRST n ROWS ONLY
Top
Click the +1 button below to share it with your friends and colleagues
Share this if you liked it!