var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select Distinct
I would like to select in a SQL Server table each field called "id" where "clientname" is different.
I mean for each same clientname there are various "id". I want to get them.
I know there is a DISTINCT stetment but i don't get the result i Want
Why don't u use a group by?
Select ID, NAME from TABLE GROUP BY ID, NAME
select id, clientname
where clientname in
( select clientname
group by clientname
having count(*) > 1 )