query to retrieve middle row of a table

[sushanta123]

I want to retrieve the middle row of a table..but i am not sure of any query in DB2 and is there any function to retreive the row number..if yes plz explain with an example.


Thanx in advance
Sushanta

[r035198x]

Have a read at the
FETCH FIRST n ROWS clause.
You can also use the ROW_NUMBER() function depending on your version.