Hi..
i have a database in which in one table having employee posting details..
like . where he works in which month or year..
table view as
month year posting place
jan 2016 A
feb 2016 A
march 2016 B
April 2016 B
.....
Nov 2016 C
..........
Feb 2017 A
.......
Sep 2017 C
as you see. employee changes his posting palaces..
so i want result as
Month Year posting Place
Jan 2016 A
March 2016 B
Nov 2016 C
Feb 2017 A
Sep 2017 C
it mean i want only that months when employee data value change in posting place..
thanks in advance
i have a database in which in one table having employee posting details..
like . where he works in which month or year..
table view as
month year posting place
jan 2016 A
feb 2016 A
march 2016 B
April 2016 B
.....
Nov 2016 C
..........
Feb 2017 A
.......
Sep 2017 C
as you see. employee changes his posting palaces..
so i want result as
Month Year posting Place
Jan 2016 A
March 2016 B
Nov 2016 C
Feb 2017 A
Sep 2017 C
it mean i want only that months when employee data value change in posting place..
thanks in advance