var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to implement Group By, Having and Order By in T-SQL
I have to list duplicate records order by ID.
It does not work. We can't use Group By, Having and Order by in a single script?
select min(ID), FName,LName,Email,Count(*) FROM tblInfo
GROUP by FName,Lname,Email
Having Count(*)>1 Order By (ID)
.... Order By MIN(ID)
ur codings are working excelent.
SELECT MIN(ID) AS min_ID
HAVING COUNT(*) > 1