34,575
社区成员
发帖
与我相关
我的任务
分享
请给出表结构,测试数据,相关算法和需要的结果.谢谢!
--这里不对,不能直接比较的。
WHERE A.LA004 <MIN(INVLA.LA004)
SELECT INVLA.LA001 as INVLALA001,INVLA.LA009 AS INVLALA009 ,
select a.au_lname , min(city) city
from authors a left join employee b
on a.au_lname = b.lname
group by a.au_lname
select a.id , isnull(min(a.val),0) a_val
from a left join b on a.id = b.id
group by a.id