oracleÖÐÈçºÎȡʱ¼ä×îÍíµÄÄDZÊÊý¾Ý£¿

±íÃû£ºtest

±íÊý¾ÝÈçÏ£º

²¿ÃÅ¡¡¡¡¡¡ÐÕÃû¡¡¡¡¡¡Èëְʱ¼ä
A        jack      2010-1-29

A          K        2010-1-28

B          mike    2010-1-27

B          L        2010-1-26

ÏëÈ¡³öÿ¸ö²¿ÃÅÈëְʱ¼ä×îÍíµÄÄDZÊÊý¾Ý¸ÃÈçºÎÈ¡£¿

½á¹ûÈçÏ£º

²¿ÃÅ¡¡¡¡¡¡ÐÕÃû¡¡¡¡¡¡Èëְʱ¼ä
A        jack      2010-1-29

B        mike    ¡¡2010-1-27

---

SQL code:
SELECT ²¿ÃÅ,ÐÕÃû, MAX(Èëְʱ¼ä) from test GROUP BY ²¿ÃÅ,ÐÕÃû

---

select * from test t
where not exists(
  select 1 from test where ²¿ÃÅ=t.²¿ÃÅ and Èëְʱ¼ä>t.Èëְʱ¼ä)

---

SQL code:

select * from test where Èëְʱ¼ä in
(
select max(Èëְʱ¼ä) from test
)

---

      Â¥ÉϵÄ3λ¶¼ÊÇÕý½â£¡

---

×îºóÒ»¸ö²»¶Ô°É¡£¡£¡£¡£¡£¡£


µÚ¶þ¸ö¡£¡£¿ÉÒÔ½âÊÍϲ»£¬Óе㿴²»¶®°¡¡£¡£¡£

---

µÄÈ·ÊÇÓÐÎÊÌâ....
SQL code

---

Code highlighting produced by Actipro CodeHighlight