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, MAX(ExpiryDate) AS ExpiryDate FROM YourTable GROUP BY CardNo, VehicleNO ORDER BY CardNo, VehicleNO
SELECT CardNo, VehicleNo, expiryDate FROM YourTableName t1 WHERE expiryDate = (SELECT MAX(expiryDate) FROM YourTableName t2 WHERE t1.CardNo = t2.CardNo)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)