Comments by ChintanHiremath (Top 1 by date)

Can someone help me with the below query, me too getting the same error

SELECT Distinct T1.QID, T1.Title, T1.Vendorid, T1.Severity, T1.Published, Total
FROM Missing_Patch_Table T1,
(
SELECT QID, COUNT (IP) as Total
FROM Missing_Patch_Table
Group by QID
) as T2
where T1.QID = T2.QID
Order by Total desc, Severity, QID;

This works fine when executed in the SQL Server, but when I use this query in VB or C# I get an error