发表于 2009-1-5 19:48
| 
SQL璇硶锛氱敤sql璇彞鏌ュ嚭鏌愬瓧娈靛唴瀹圭浉鍚
鍙戝竷: 2008-7-01 14:14 | 浣滆: 缃戠粶杞浇 | 鏉ユ簮: 缃戠粶杞浇 | 鏌ョ湅: 70娆
SQL璇硶锛氱敤sql璇彞鏌ュ嚭鏌愬瓧娈靛唴瀹圭浉鍚岋紝鍙彇鍙﹀涓涓瓧娈垫渶澶х殑琛
sql璇彞锛氭煇瀛楁鍐呭鐩稿悓锛屽彧鍙栧彟澶栦竴涓瓧娈垫渶澶х殑琛
CREATE TABLE t_tab1(
f_id number not null primary key,
f_content_type varchar2(10) not null,
f_content1 varchar2(140) , -- 淇℃伅1
f_content2 varchar2(140) , -- 淇℃伅2
f_content3 varchar2(140) , -- 淇℃伅3
f_content4 varchar2(140) , -- 淇℃伅4
f_date date default sysdate, -- 褰曞叆鏃ユ湡
f_status char(1)
);
insert into t_tab1 values(1,'5681','绗竴1鏉','绗21鏉','绗31鏉','绗41鏉',sysdate,'0');
insert into t_tab1 values(2,'5681','绗竴22鏉','绗22鏉','绗32鏉','绗42鏉',sysdate,'0');
insert into t_tab1 values(3,'5682','绗竴鏉','绗2鏉','绗3鏉','绗4鏉',sysdate,'0');
insert into t_tab1 values(4,'5683','绗竴鏉','绗2鏉','绗3鏉','绗4鏉',sysdate,'0');
insert into t_tab1 values(5,'5684','绗竴鏉','绗2鏉','绗3鏉','绗4鏉',sysdate,'0');
insert into t_tab1values(6,'5685','绗竴鏉','绗2鏉','绗3鏉','绗4鏉',sysdate,'0');
insert into t_tab1 values(7,'5685','绗竴7鏉','绗2鏉','绗3鏉','绗4鏉',sysdate,'0');
insert into t_tab1values(8,'5685','绗竴鏉','绗2鏉','绗3鏉','绗4鏉',sysdate,'0');
鎯抽夊嚭璺濈鐜板湪鏃堕棿鏈杩戠殑锛屽悇涓嶇浉鍚岀殑f_content_type,鍙互浣跨敤濡備笅璇彞
select * from t_tab1 a,(
select f_content_type,max(f_date) d from t_tab1 group by f_content_type) b
where a.f_content_type=b.f_content_type and a.f_date=b.d
