cardno vehicleno expirydate 12 ap20aa4779 06/18/12 11:50:06 14 ap20aa4777 06/05/12 11:20:36 14 ap20aa4777 06/15/12 10:46:20 14 ap20aa4777 06/15/12 10:49:20 14 ap20aa4777 06/15/12 10:55:06 14 AP20AA4777 06/18/12 11:11:00 9523 AP123123 06/18/12 13:09:24
12 ap20aa4779 06/18/12 11:50:06 14 AP20AA4777 06/18/12 11:11:00 9523 AP123123 06/18/12 13:09:24
SELECT CardNo, VehicleNo, expiryDate FROM YourTableName t1 WHERE expiryDate = (SELECT MAX(expiryDate) FROM YourTableName t2 WHERE t1.CardNo = t2.CardNo)
SELECT CardNo, VehicleNO, MAX(ExpiryDate) AS ExpiryDate FROM YourTable GROUP BY CardNo, VehicleNO ORDER BY CardNo, VehicleNO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)