ÈçºÎÈ¡Ò»¸ö±íµÄ·Ö×éÖÐʱ¼ä×îÍíµÄÒ»Ìõ¼Ç¼£¿(oracle)

»·¾³£ºoracle 9i
±íÃû£ºtable

name                        time

mike                        20100209-00:10:01:123
mike                        20100209-00:02:01:234
mike                        20100208-09:02:05:564


ÏëµÃµ½½á¹û£º

name                        time

mike                        20100209-00:10:01:123

Çë½Ì¸÷λ¡¡²éѯÓï¾äÓ¦¸ÃÈçºÎд£¿

---

SQL code:

SELECT NAME,TIME
from table
WHERE (NAME,TIME) EXISTS
(SELECT NAME,MAX(TIME) from table GROUP BY NAME)

---

select name,max(time) from table group by name

---

select name,time from
  (select row_number () over ( partition by name order by time desc) rn,t.name,t.time from table t)
where rn=1;

---

select name,time from
  (select row_number () over ( partition by name order by time desc) rn,t.name,t.time from table t)
where rn=1;

---

SQL code

---

Code highlighti