[sushanta123]

Hi Every1,

Actually i want to retrieve the middle row(record) of a table, but i am not able to write any query to get the same..

Also i am not sure whether any function as Rownum in ORACLE that exists in DB2 or not!! If yes then can any one explain in details...

Cheers..
Thanks in advance

Sushanta

[docdiesel]

Hi,

there's a ROW_NUMBER() OVER() functionality in DB2. You could create a view containing this function, e.g.:

Expand|Select|Wrap|Line Numbers

1. Create View
2.   schema.v_numbered
3. as
4.   Select
5.     ROW_NUMBER() OVER() as ROWNO,
6.     id,and,other,columns
7.   From
8.     schema.mytable ;

and then search for the row no. ( count(rows) DIV 2 ).

Regards

Doc Diesel