17,382
社区成员




select * from
(select distinct a.*,row_number() over(partition by b.b_id order by b.cr_date)rn
from a,b
where a.s_id = b.s_id(+)
and a.c_s = '1' )t
where t.rn =1SELECT *
FROM a t1
WHERE c_s = 1
AND EXISTS
(SELECT 1 FROM b WHERE b.s_id = t1.s_id AND TO_CHAR(cr_date,'yyyy') = '2012'
);
select b.b_id, b.s_id, b.cr_date, a.name, a.sname from b
left join a on b.s_id=a.s_id
where a.c_s=1
order by b.cr_date desc