SQLServer中有这样的语句:
SELECT
a.col1, b.col1, b.col2
FROM ta a
CROSS APPLY (
SELECT
tb.col1, tb.col2
FROM tb
WHERE tb.col3 = a.col1
)b
GROUP BY a.col1;
这样的语句,mysql怎么实现??
SELECT
a.col1, b.col1, b.col2
FROM ta a
CROSS APPLY (
SELECT
tb.col1, tb.col2
FROM tb
WHERE tb.col3 = a.col1
)b
GROUP BY a.col1;
这样的语句,mysql怎么实现??
SELECT
a.col1, b.col1, b.col2
FROM ta a,tb b
WHERE b.col3 = a.col1
GROUP BY a.col1;
贴建表及插入记录的SQL,及要求结果出来看看
A是统计表,字段如下:
UserID,DepartA(部门), TJA,TJB
B是流水表
SEQ(自增), UserID, Act1,Act2
现在结果要求:从A和B表中加载所属部门为‘YX’ 所有人员的最后两条行为信息。
贴建表及插入记录的SQL,及要求结果出来看看
所有人员的最后两条行为信息:什么标准,SEQ最大?select b.* from b
inner join a on a.UserID=b.UserID
where 2>(select count(*) from b where a.UserID=UserID and a.seq<seq)
and DepartA='YX'
inner join a on a.UserID=b1.UserID
where 2>(select count(*) from b where b1.UserID=UserID and b1.seq<seq)
and a.DepartA='YX'
from A inner join B x on a.UserID=x.UserID
where DepartA='YX'
and 2>(select count(*) from B where UserID=x.UserID and SEQ>x.SEQ)