Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Ravanabrahma Celebrity Bewarse Username: Ravanabrahma Post Number: 22570 Registered: 06-2004 Posted From: 99.67.74.174 Rating: N/A Votes: 0 Posted on Friday, December 21, 2012 - 7:32 pm:    Lenevo: lenovo baa..thanks for the help. there were 2 columns, changed date and last_change_date. so oka query raasi order by change date annanu and rownum = 1 annanu. latest row vachindi. induloni last_change_date = ani subquery rasanu where changed_date = last_change_date ani. and I used salary >= 50000 and < 50000 vaadanu. its working good If the performance is bad, then I will try to use the rank function that you said. I tried to use that but didn't understand exactly the rank over partition. konchem chadivi chestha idi