Hi everybody,



I work in Db2 V8 and my OS is Z o/s.



I have a doubt that in Oracle without knowing anything about records ,
we can fetch a row by means of its rownum .



For example :



If we want to fetch the 5th row of a table we can do that by means the
following query



Select * from table where rownum = 5;



I just want to know what we can use in db2 to fetch a row like what I
have done in the above example.



Could anyone help me out in the above scenario.



regards,

bala





============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

DB2 & UDB email list listserv db2-l LazyDBA home page