hi
How to Restrict duplicate latest datetime records only show in this code
create table enamelist
(
id int primary key identity(1,1),
EmpId int,
EmpName varchar(100),
EmpCreatedDate datetime
)
select * from enamelist
insert into enamelist values(1,'John',getdate())
insert into enamelist values(1,'John',getdate())
insert into enamelist values(2,'Gilbert David',getdate())
insert into enamelist values(2,'Gilbert David',getdate())
insert into enamelist values(3,'Rufees David',getdate())
insert into enamelist values(3,'Rufees David',getdate())
insert into enamelist values(4,'Denish David',getdate())
insert into enamelist values(5,'ReDenish David',getdate())
SELECT ID,EMPID,EMPNAME,EMPCREATEDDATE FROM ENAMELIST
GROUP BY ID,EMPID,EMPNAME,EMPCREATEDDATE
-- My Data Like this. but i put group also but Duplicate records shows here because Datetime Different so
-- that record comes. But i need every Duplicate records i need latest EMPCREATEDDATE only show
-- When Duplicates Records i need shows latest dateand time only show
-- I need output this in Sql Query
Sno EMPID name createddate
1 1 John 2017-01-13 11:23:02.370
2 2 Gilbert John 2017-01-13 11:23:02.380
3 3 Rufees John 2017-01-13 11:23:02.427
4 4 Denish David 2017-01-13 11:26:24.327
5 5 ReDenish David 2017-01-13 11:26:24.357
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com