sql left jion on 获得的记录取第一条记录，怎么写？

答案:2 悬赏:10

解决时间 2021-03-13 15:43

提问者网友：深爱及嗨
2021-03-13 11:19

SELECt
l_title.l_id,l_title.bigclass,l_title.name,l_title.title,l_title.click,l_title.addtime,h_hf.addtime,h_hf.l_id,h_hf.name
from l_title
left join h_hf on
h_hf.l_id=l_title.l_id
where l_title.bigclass="&rs("m_id")&"
order by h_hf.addtime desc , l_title.addtime desc

access数据库。

最佳答案

二级知识专家网友：如果这是命
2021-03-13 12:38

SELECt top 1
l_title.l_id,l_title.bigclass,l_title.name,l_title.title,l_title.click,l_title.addtime,
(select top 1 h_hf.addtime from h_hf where l_id=l_title.l_id order by h_hf.addtime desc,h_hf.l_id) as h_hfaddtime,
  (select top 1 h_hf.l_idfrom h_hf where l_id=l_title.l_id order by h_hf.addtime desc,h_hf.l_id) as h_hfl_id,
  (select top 1 h_hf.h_hf.name h_hf where l_id=l_title.l_id order by h_hf.addtime desc,h_hf.l_id) as h_hfname
from l_title
where l_title.bigclass="&rs("m_id")&"
order by   l_title.addtime desc,l_title.l_id desc

全部回答

1楼网友：而你却相形见绌
2021-03-13 13:39

SELECt l_title.l_id,l_title.bigclass,l_title.name,l_title.title,l_title.click,l_title.addtime,h_hf.addtime,h_hf.l_id,h_hf.namefrom l_titleleft join h_hf on h_hf.l_id=l_title.l_id where l_title.bigclass="&rs("m_id")&" and h_hf.addtime=(select max(addtime) from h_hf) and l_title.addtime=(select max(addtime) from i_title) order by h_hf.addtime desc , l_title.addtime desc

我要举报

如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！