Find Status based on min and max dates

[Anonymous]

Hi experts,

I have a requirement sample data attached.

1)I have mobile numbers and enquirers came from on online other sources(2 sources). find the mobile number came from which source first based on date fields.

2)based on enquiry need recent status.

TIA

Regards

Pavan

[YoussefBelloum]

Hi,

you can use flags to create a new column on each source.