Baurisetty Dhiraj

• Aug 28th, 2011

 

select * from (select * from (select * from table_name order by rowid desc) where rownum<=5) order by rownum desc

chhavis928

 Profile Answers by chhavis928 Questions by chhavis928

• Sep 14th, 2011

 

Thanx for replying..but i was not asking in oracle...i was asking in DB2

agost003

 Profile Answers by agost003 

• Sep 24th, 2011

 

select col1, col2, col3
from tbl1
order by col1 desc, col2 desc, col3 desc
fetch first 5 rows only

wanilkumar

 Profile Answers by wanilkumar 

• Oct 6th, 2011

 

You may use the "fetch last 5 rows only" clause at the end of your select query

satyanarayana

• Jan 17th, 2012

 

First sort the records by using order by clause and then issue the following query

Code
SELECT * FROM tablename fetch first 5 rows only;

Then it will give the last five records of the table

Mohit

• May 28th, 2012

 

There is nothing called "fetch last n records only" in db2...

You can use select col1 from table1 order by col1 desc fetch first 5 records only

madhavan

• Mar 10th, 2014

 

SELECT * FROM Table_Name order by column_name desc Fetch first 5 rows only;