首页新闻找找看学习计划

这句有点乱的SQL怎么改成LINQ?

0
悬赏园豆:30 [已关闭问题] 关闭于 2014-04-22 16:59

SELECT DISTINCT Kind,CNAME,( select to_number(Substr(kind,2,length(kind)-1)) from BatchCLIENT2KIND where kind <> 'all' and kind = k.kind)  serno,(SELECT Remain_Person FROM RemoteTakeQuota WHERE DEP_CODE IS NULL AND OverDate=0 AND Kind=k.Kind)  Weekdays, (SELECT Remain_Person FROM RemoteTakeQuota WHERE DEP_CODE IS NULL AND OverDate=1 AND Kind=k.Kind)  WeekdSaturdayays, (SELECT Remain_Person FROM RemoteTakeQuota WHERE DEP_CODE IS NULL AND OverDate=2 AND Kind=k.Kind)  Sunday FROM BatchCLIENT2KIND k ORDER BY serno

许大虾的主页 许大虾 | 初学一级 | 园豆:12
提问于:2014-04-18 09:28
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册