¼òµ¥sql²éѯ

Ò»¸öÓû§±íUser£¨id,name£©Ò»¸öÎÄÕ±íAtical(id,UserId,content,EntryTime)
²é³öÿ¸öÓû§×îз¢±íµÄһƪÎÄÕ¡£ÔÚÏߵȴýÖС£¡£¡£¡£

---

SQL code:
select a.*,
b.*
from [User] a,Atical b
where a.id=b.UserId
and not exists(select 1 from Atical where UserId=b.UserId and EntryTime>t.EntryTime)

---

Â¥ÉϵĻ¹ÔÚÂð£¿ÄãµÄ·½·¨Ã²ËƲ»Ðа¡¡£ÕâÑù²é³öµÄÊÇ×îºó·¢±íµÄһƪÎÄÕ°¡¡£ÎÒÒªµÄÊÇÿ¸öÓû§µÄ×îºó·¢±íµÄһƪÎÄÕÂ

---

SQL code:
--¾ÍÊÇÿ¸öÓÃ戶°¡,UserId²»¾ÍÊÇÓÃ戶麼
select a.*,
b.*
from [User] a,Atical b
where a.id=b.UserId
and not exists(select 1 from Atical where UserId=b.UserId and EntryTime>b.EntryTime)

---

with cte as(
select
      *,
  row_number() over(partition by a.userid order by EntryTime desc) as rn
from Atical
)

select a.*,b.*
from [User] a,cte b
where a.id=b.UserId and b.rn=1

---

ÒýÓÃ

Â¥ÉϵĻ¹ÔÚÂð£¿ÄãµÄ·½·¨Ã²ËƲ»Ðа¡¡£ÕâÑù²é³öµÄÊÇ×îºó·¢±íµÄһƪÎÄÕ°¡¡£ÎÒÒªµÄÊÇÿ¸öÓû§µÄ×îºó·¢±íµÄһƪÎÄÕÂ

½¨ÒéÂ¥Ö÷²âÊÔһϣ¬²âÊÔ½á¹û¼´ÕæÀí

---

select userid,name,content,b.id,entrytime
from user a,atical b
where a.id=b.userid and entrytime in (sel