How can i get the minimum id value under only same combo

Question

id combo 1 1 2 2 3 2 4 1 in this table i want only min id value for same cobmofor example from the above table combo's are 1 and 2 i want only 2nd combo within 2nd combo i want only min id

Ananth G · Answer

SELECT a.ida.combo FROM ( SELECT ROW_NUMBER()OVER(PARTITION BY SET1.combo ORDER BY SET1.id ASC ) AS ROWNUMBERS SET1.id SET1.combo FROM ( SELECT id combo FROM tablecombo GROUP BY combo HAVING COUNT (*) > 1 ) SET1 )a WHERE a.ROWNUMBERS=1

Esakki Muthu · Answer

Hi Siva Try this Create table Combo(ID Intcombo int) insert into Combo values(11) insert into Combo values(22) insert into Combo values(31) insert into Combo values(42) insert into Combo values(53) insert into Combo values(64) insert into Combo values(81) insert into Combo values(96) insert into Combo values(105) insert into Combo values(112) with com as (Select combo from Combo group by combo ) Select min(c.ID)co.combo from Combo c join com co on c.combo = co.combo group by co.combo

Manas Mohapatra · Answer

In SQL: SELECT MIN(id) As MinId FROM tblTemp WHERE combo = 2 GROUP BY combo; In LINQ: int minId = (from p in records group p by p.combo into g where p.combo = 2 select new { combo = g.key minid = g.id.Min() }).SingleOrDefault().minid;

Prakash Kumar · Answer

Use the following query while using group by we will get the min id for same values. select min(id)idcombo from tablecombo where combo =2 group by combo