Replacing values in the next record..??

[Silambarasan1306]

Hi All,

I have table below mentioned.

DATE	BRAND	PRODUCT	RATE
6/1/2016	ABC	SMPO	5000
6/1/2016	DTC	APLE	4300
6/1/2016	VGS	CART	2000
6/1/2016	CTG	BEGTS	7000
6/1/2016	OTS	NTB	9000
6/2/2016	ABC	LPS	3000
6/2/2016	DTC	ORG	7500
6/2/2016	VGS	ONIN	3000
6/2/2016	CTG	SHTS	9500
6/2/2016	OTS	PEN	1500
6/3/2016	ABC	SMPO	3500
6/3/2016	VGS	TNTA	5500
6/3/2016	DTC	STANE	4500
6/3/2016	OTS	NTB	7000
6/4/2016	ABC	HRDH	6500
6/4/2016	DTC	ORG	4000
6/4/2016	CTG	PSNJ	8000
6/4/2016	OTS	NUS	3700
6/5/2016	ABC	LPS	5600
6/5/2016	VGS	BHA	2200

In this,

I have some records on 6/1/2016. the same record to be there in the following dates. The price is as mentioned. If the same record not in the another date, then the Price values to be replaced before record value.

Thanks.

[jayaseelan · Accepted solution]

Hi Silambarasan,

     I have got your desired output.

      Please find the attachment.

Thanks

[agni_gold]

Can you please provide your required result , that will help.

[Silambarasan1306]

Thanks for the reply guys.

I got the expected output.