ÇóÒ»¸ösqlÓï¾ä¡£¡£¡£ - Oracle / ¿ª·¢

Ò»¹²Á½ÁÐ
id time
1 201009
2 201009
3 201009
1 201009
1 201009
2 201009
4 201009
Ç󣬣¬Ä³Ò»Ê±¼äµã»÷Á¿×î´óµÄidºÅ£¿£¨oracle£©

---

select time,max(id) from tablename
group by time

---

SQL code:


select id,time,max(id) keep(dense_rank last order by count(*)) ×î´óid
from tb
where time between t1 and t2
group by id,time

---

select max(id) from tb where time =ijһʱ¼ä

---

select id,time from
(
select id,count(id) num,time from table
where time = 'ijһʱ¼ä'
group by time,id
order by num desc
)
where rownum =1;

---

select id from
(
select id,count(id) num,time from table
where time = 'ijһʱ¼ä'
group by time,id
order by num desc
)
where rownum =1;

---

SQL code:

--Ç°ÃæµÄÐÞÕýÏÂ
SQL> edi
ÒÑдÈë file afiedt.buf

1 select max(id) keep(dense_rank last order by count(*))
2 from tb
3 where time ='201009'
4* group by id
SQL> /

MAX(ID)KEEP(DENSE_RANKLASTORDERBYCOUNT(*))
------------------------------------------
1

---

ÒýÓÃ

ÒýÓà 5 Â¥ adebayor µÄ»Ø¸´:

select i