我有一个查询
select *
from Datatable
where A in (select A
from(subselect Q)
and B in (select B from(subselect Q)
但这不会像我想要的那样。
在我的结果中,A和B必须位于同一行,但是我不知道该怎么做。
编辑:
数据表:
KundeVersionID,Zeitpunkt,KundeID 16,2014-08-05
18:31:10.317,10;
17,2013-11-27 16:26:53.980,11
select * from Datatable
where (Zeitpunkt in (select Zeitpunkt from
(select KundeID, MAX(Zeitpunkt) as Zeitpunkt from KundeVersion
group by KundeID)As Q)
and KundeID in(select KundeID
from (select KundeID,MAX(Zeitpunkt) as Zeitpunkt
from KundeVersion group by KundeID)As Q)) order by KundeID
希望这可以帮助
您可以在FROM
子句中使子查询看起来像一个表:
select
* --TODO - proper column list
from
Datatable dt
inner join
(select KundeID, MAX(Zeitpunkt) as Zeitpunkt from KundeVersion
group by KundeID) q
on
dt.KundeID = q.KundeID and
dt.Zeitpunkt = q.Zeitpunkt
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句