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
 

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;