请教 这样的SQL语句怎么写？在线急等！！！

[vincent_utem]

select * from dbo.DownLoadFolder
where pgid in (
select id from dbo.DownLoadFolder
where pgid in (
select id from dbo.DownLoadFolder
where pgid in (select id from dbo.DownLoadFolder where id = 277)
))
order by id

[lijavasy]

select * from dbo.DownLoadFolder where pgid=id and id=227 order by id;
不是这个吗?

[q107770540]

linq to sql 中的in 操作实现 , 参考：

 string s = " 80,81,83,82";
        string[] s1 = s.Split(',');
        int[] p = new int[s1.Count()];

        for (int i = 0; i < s1.Count(); i++)
        {
            p.SetValue(Convert.ToInt32(s1[i]), i);
        }
       
       
       
        public IQueryable<tbQuestions> SelectQuestions(int[] p)
        {
            var result = from s1 in db.tbQuestions
                         where !p.Contains(s1.id) && s1.deleteFlag == 0
                         select s1;
            return result;
        }

[justsoloving]

顶啦，

[丰云]

var result = dbcontext.DownLoadFolders.SingleOrDefault(p=>p.id = 227).Orderby(q=>q.id);

[丰云]

[Quote=引用楼主 vincent_utem 的回复:]
select * from dbo.DownLoadFolder
where pgid in (
select id from dbo.DownLoadFolder
where pgid in (
select id from dbo.DownLoadFolder
where pgid = 277)
))
order by id
[/Quote]

写成 select * from dbo.DownLoadFolder where

[喜-喜]

[Quote=引用 1 楼 lijavasy 的回复:]
select * from dbo.DownLoadFolder where pgid=id and id=227 order by id;
不是这个吗?
[/Quote]

up...

[丰云]

搂主代码哆嗦，
给你简化点：

select * from dbo.DownLoadFolder
 where pgid in (select id from dbo.DownLoadFolder
                 where pgid in (select id from dbo.DownLoadFolder
                                 where pgid = 277)
               )
order by id

写成linq to sql,有点麻烦，要再想想，前面的考虑不周

[丰云]

var result = from a in dbcontext.DownLoadFolders
             join b in dbcontext.DownLoadFolders
               on a.pgid Equals b.id 
             join c in dbcontext.DownLoadFolders
               on b.pgid Equals c.id 
             join d in dbcontext.DownLoadFolders
               on b.pgid Equals d.id 
            where d.id = 277
           select a;

[丰云]

忘记加排序。。。
自己会加吗？
我还是给你加上吧

var result = (from a in dbcontext.DownLoadFolders
              join b in dbcontext.DownLoadFolders
                on a.pgid Equals b.id 
              join c in dbcontext.DownLoadFolders
                on b.pgid Equals c.id 
              join d in dbcontext.DownLoadFolders
                on b.pgid Equals d.id 
             where d.id = 277
            select a).Orderby(p=>p.id);

[丰云]

前面等号写错咯：
where d.id == 277

[scdn8311]

我也学习了