Select Distinct latest updated value in SQL Server

meetsree...

SOLVED CLOSED ACTIVE ANSWERED
User: meetsree83
Posted: on Jun 17, 2019 12:09 AM
Forum: SQL Server
Replies: 7
Views: 3143

Dear All,

I have some datas in DB. I need to fetch datas by avoiding the duplicate records.

Based on the NO we will get duplicate records. If 2 records come for same NO, then we need one record with latest modifications implemented on the rows.

UPDATE value is the latest modifications data.

For example: If MOb NO chnaged the the new mob no will be fetch and gave the o/p as one record.

Plesae help.

DB
Sl No	Action	No	Mob	Email	Status	Date
1	ADD	123	1542	a@f.com	0	16/6/2019
2	ADD	1563	1425	b@f.com	0	16/6/2019
3	ADD	111	123	e@f.com	0	17/6/2019
4	ADD	222	1234	f@f.com	0	17/6/2019
5	UPDATE	222	12345	f@f.com	0	17/6/2019
6	ADD	333	12345	r@f.com	0	17/6/2019
7	UPDATE	333	1256	tt@f.com	0	17/6/2019

Output
Action	No	Mob	Email
ADD	123	1542	a@f.com
ADD	1563	1425	b@f.com
ADD	111	123	e@f.com
ADD	222	12345	f@f.com
ADD	333	1256	tt@f.com

Regards

Sreejith

Download FREE API for Word, Excel and PDF in ASP.Net

meetsree...

0 5

Reply
User: meetsree83
Replied: on Jun 17, 2019 02:34 AM
Report

UPDATE value is the latest modifications data.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Select Distinct latest updated value in SQL Server

Company

Explore

Follow us

Contact Us