How can you say which is thir record when all the salaries 
are same...

We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,

like select col1,col2,rownum
from tab1
where rownum=3

Based on the empid(assuming the persons are employees) us 
can fire a quiry on that id.

hi all,
 suppose 4 emp geting same sal as 4000... select * from emp 
where sal=4000 and/having rowid=3

Hi pooja,

would rowid be 3?
can u use having clause in ur query?

pl let me know poojaa