manikanta1207 (7/3/2013)
give me an ex please
because this seems a lot like homework, i only offered a partial SQL to help you think about the issue;
this doesn't pass a syntax check but provides a couple of clues as to how to tackle the issue
SELECT * FROM (select row_number() over(partition by order by.....) As RW FROM SOMETABLE ) myAlias Where RW = 3
if you can show your work, and tell us what isn't working, we could help you understand the concepts behind solving the issue.
Lowell