select * from taxdetails WHERE convert(varchar,choosed_date,103)=(select max(varchar,choosed_date,103) from taxdetails)
WHERE
Taxvalue Recent_Date ---------------------- 13 24/09/2012
select taxvalue, max(convert(varchar,choosed_date,103)) as Recent_Date from taxdetails where Choosed_date= (select max(Choosed_date) from taxdetails)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)