sql - Return only records where there is a difference in field data -

sql - Return only records where there is a difference in field data -

return records there difference in fte or position title field.

i have table of employee info fields employee#, job#, start date fte , position. each employee , job want homecoming records there alter in fte or position

record,employee#,job#,start date, fte,position 1, 1000, 01, 01/01/2011, 100, 2, 1000, 01, 01/06/2011, 100, 3, 1000, 01, 01/07/2011, 80, b 4, 1000, 01, 01/08/2011, 80, c 5, 1000, 01, 01/10/2011, 80, c 6, 1000, 02, 01/01/2011, 20, 7, 1000, 02, 01/05/2011, 20, 8, 1000, 02, 01/08/2011, 20, b

the query should homecoming records 1, 3,4,6,8. (these records fte , position different previous row)

this looks typical self-join scenario: need query table 1 time again , see if there's before record different fte or position.

something (no did not seek this):

select later.* my_table later, my_table before -- same table 1 time again later.employee = earlier.employee -- self-join , later.date > earlier.date -- lest see changes twice , later.fte != earlier.fte -- alter ;

sql toad