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: 22567 Registered: 06-2004 Posted From: 99.67.74.174 Rating: N/A Votes: 0 Posted on Friday, December 21, 2012 - 2:06 pm:    naaku oka table A undi. A Data: ID Salary change_date 123 48,200 09/10/2012 123 55,000 05/01/2012 123 54,000 04/01/2012 I want to display the latest row from the table by using the change_date if the salary changed either to > 50,000 or to < 50,000 so for an ID in the table 3 rows exists. I need to check the latest row salary is either moved to > 50K or < 50K and diplay the latest row. current data lo for ID 123, the latest row salary was changed to < 50K so need to display that latest row. ela rayali query?