Bill no userid amt billenterdate 1 1 100 2012-05-24 05:29:35.223 2 2 200 2012-03-24 05:29:35.223 3 2 200 2012-01-24 05:29:35.223 4 1 2000 2012-05-4 05:29:35.223
1 1 100 2012-05-24 05:29:35.223 2 2 200 2012-03-24 05:29:35.223
Select BillNo,userid, amt, billenterdate From ( SELECT BillNo,userid, amt, billenterdate, Rank() over (Partition BY userid order by Cast(Convert(varchar,billenterdate,106) as datetime) Desc) as [Rank] FROM TblBillDetails ) A where [Rank]=1
select * from Table_1 a inner join (select max(billenterdate) as billenterdate,userid from Table_1 group by userid) as userinfoTable on a.billenterdate = userinfoTable.billenterdate and a.userid = userinfoTable.userid order by billno
EXISTS
SELECT * FROM YourTable t1 WHERE NOT EXISTS (SELECT 1 FROM YourTable t2 WHERE t2.UserId = t1.UserId AND t2.BillEnterDate > t1.BillEnterDate)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)