we need latest modified record from Database based modified time and Primarykey:

[Srinivas]

Dear Friends,

I have one query

When we are extraction from data base that data should be based on primary key and creation date we are pinking the data.Here one query primary key may be may not be same but we need to pick latest modified record that's depend on time , This latest modified record based on time we will knows.

see below screen shot for understanding :

here my output is below one because those are latest modified records:

Advance Thanks,

Munna

[deepakqlikview_123]

I will suggest you to use where not exist clause by using primary key in your script.

Thanks

[Srinivas · Accepted solution]

Hi Frds,

all most got the solution through below code

Thanks,

Munna

[Srinivas]

Thanks for your valuable suggestion Deepak,

Regards,

Munna