没有用过 MySql 不知道这样对不对 兄弟试试看吧select distinct b.Fff , a1.fff as ff1 , a2.fff as ff2 , a3.ff as ff3 from mytb b left outer join myta a1 on a1.Fid= b.fid limit 0,1 left outer join myta a2 on a2.Fid= b.fid limit 1,1 left outer join myta a3 on a3.Fid= b.fid limit 2,1
楼上 的语句在那里运行阿 oralce 中一个语句中可以有多个limit吗?
select distinct mytb.Fff,(select myta.fff from myta,mytb where Fid= mytb.f id limit 0,1) as ff1, (select myta.fff from myta,mytb where Fid=mytb.fid limit 1, 1) as ff3,(select myta.fff from myta,mytb where Fid=mytb.fid limit 2, 1) as f f3 from mytb;
谢谢 allright_flash 您的可以成功但是有错误更改如下 select distinct mytb.Fff,(select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 0,1) as ff1, (select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 1,1) asff3,(select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 2, 1) as ff3 from mytb;
不知道这样对不对
兄弟试试看吧select distinct b.Fff , a1.fff as ff1 , a2.fff as ff2 , a3.ff as ff3
from mytb b
left outer join myta a1 on a1.Fid= b.fid limit 0,1
left outer join myta a2 on a2.Fid= b.fid limit 1,1
left outer join myta a3 on a3.Fid= b.fid limit 2,1
oralce 中一个语句中可以有多个limit吗?
id limit 0,1) as ff1, (select myta.fff from myta,mytb where Fid=mytb.fid limit
1, 1) as ff3,(select myta.fff from myta,mytb where Fid=mytb.fid limit 2, 1) as f
f3 from mytb;
您的可以成功但是有错误更改如下
select distinct mytb.Fff,(select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 0,1) as ff1, (select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 1,1) asff3,(select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 2, 1) as ff3 from mytb;