¼òµ¥µÄSQLÓï·¨,ÔÚÏßµÈ - MS-SQL Server / »ù´¡Àà

ÎÒÓÐÒ»¸öÓÃÀ´×öÈÕÖ¾µÄÊý¾Ý±í,±í½á¹¹ÈçÏÂ

Ô´ ʱ¼ä ÐÅÏ¢  
a 12£º30 OOXX  
a 12£º40 XXOO  
b 9£º00 OXOX  
b 13£º17 XOXO
a 15£º40 OXXO

ÏÖÔÚÎÒÏëÓÃ×î¼òµ¥µÄÓï·¨À´È¡µÃËùÓÐÔ´µÄ×î½üÒ»ÌõÐÅÏ¢,SQLÓ¦¸ÃÔõÑùдÄØ?ÎÒÖ»»áÓÃTOP 1 order by Õâ¸ö·½·¨
ÎÒÏëÈ¡µÃµÄ½á¹ûÊÇ
a 15:40 OXXO
b 13:17 XOXO

ÔÚÏßµÈ

---

SQL code:
select * from tb t where ʱ¼ä=(select max(ʱ¼ä) from tb where Ô´=t.Ô´)

---

ÒýÓÃ

SQL code
select * from tb t where ʱ¼ä=(select max(ʱ¼ä) from tb where Ô´=t.Ô´)

ÄãµÄÕâ¸öд·¨ÓÐÎÊÌâµÄ

---

SQL code:
select * from tb t where cast(ʱ¼ä as datetime)=(select max(cast(ʱ¼ä as datetime)) from tb where Ô´=t.Ô´)

---

SQL code:
SELECT * from [table] a WHERE NOT exists(SELECT 1 from [Table] WHERE Ô´=a.Ô´ and RIGHT('0'+ʱ¼ä,5)>RIGHT('0'+a.ʱ¼ä,5))

---

SQL code:

select * from tb t where not exists(select 1 from tb s where t.Ô´=s.