How to this query convert to linq queries?
select top 100 percent a,b,c,d,ROW_NUMBER() over(PARTITION BY a,b order by a,b) as NUMBER FROM TABLEA AS TA group by a,b,c,d
INSERT INTO TABLEB (a,b,f,q,u,p)
from klm ,(select a,b,ceiling((count(*) + x + )
group by (a,b) GRP
where klm.a=GRP.a and
What I have tried:
var x= from tablesa in TABLEA
select a,b,c,d //but dont write percent and after query.