fetch the distinct salary details

[askspepsi]

Greeting all,

I have the below table of salary details with designation with increment details of employees.

I like to have the below desired output.

please help me.

My Table

Desired Output:-

[vanessafvg · Accepted solution]

I have put something together to give you an idea of how you could do this.    It really depends on whether you want this to be repeatable, if there are other things to consider etc. etc  see attached

[vanessafvg]

please share data in text format.  

[askspepsi]

Dear all, 

Any update for the above query I raised? 

[smpa01]

@askspepsi  what is the logic?

[askspepsi]

Table

Employee Id	Basic Pay	HRA	Transport Allowance	Other Allowance	Total Salary	EffectiveFrom	EffectiveTo	RecordStatus	Designation
40	1650				1650	01/04/2020		Current Salary	Senior Camp Administrator
40	1650				1650	01/02/2020	31/03/2020	Previous Salary	Senior Camp Administrator
40	1650				1650	01/12/2019	31/01/2020	Previous Salary	Senior Camp Administrator
40	1650				1650	01/07/2019	30/11/2019	Previous Salary	Senior Camp Administrator
40	1650				1650	01/01/2019	30/06/2019	Previous Salary	Camp Administrator
40	750				750	07/12/2013	31/12/2018	Previous Salary	Camp Administrator
41	1200	500	50	30	1780	01/01/2021		Current Salary	HR Administrator
41	1200	500	50	30	1780	01/02/2020	31/03/2020	Previous Salary	HR Administrator
41	1200	500	50	30	1780	01/12/2019	31/01/2020	Previous Salary	HR Administrator
41	1200	500	50	30	1780	01/07/2019	30/11/2019	Previous Salary	Assistant HR Administrator
41	1200	500	50	30	1780	01/06/2019	30/06/2019	Previous Salary	Assistant HR Administrator
41	750	450	50	30	1280	01/01/2019	31/05/2019	Previous Salary	Assistant HR Administrator
41	400	300	50	30	780	21/12/2013	31/12/2018	Previous Salary	Assistant HR Administrator

Output:-

Employee Id	Basic Pay	HRA	Transport Allowance	Other Allowance	Total Salary	EffectiveFrom	Designation
40	1650				1650	01/02/2020	Senior Camp Administrator
40	1650				1650	01/07/2019	Senior Camp Administrator
40	1650				1650	01/01/2019	Camp Administrator
40	750				750	07/12/2013	Camp Administrator
41	1200	500	50	30	1780	01/02/2020	HR Administrator
41	1200	500	50	30	1780	01/12/2019	HR Administrator
41	1200	500	50	30	1780	01/12/2019	Assistant HR Administrator
41	750	450	50	30	1280	01/01/2019	Assistant HR Administrator
41	400	300	50	30	780	21/12/2013	Assistant HR Administrator