sql¸ßÊÖ°ïæ

SQL code:
select i.card_id,
(select m.names from
(select rownum as r ,t.code_detail,d.names from infectiondetail t, infection_steps d where t.code_detail = d.code and t.infection_cardid = i.card_id order by t.dt_start desc,t.addtime desc) m
where m.r<2
) diseaasestageName
from infectioncard i
where i.card_id ='-59052'



½á¹û£ºcard_id diseaasestageName
  -59052 ËÀÍöÆÚ


SQL code:

select i.card_id,
(select m.names from
(select rownum as r ,t.code_detail,d.names from infectiondetail t, infection_steps d where t.code_detail = d.code and t.infection_cardid = '-59052' order by t.dt_start desc,t.addtime desc) m
where m.r<2
) diseaasestageName
from infectioncard i
where i.card_id ='-59052'


½á¹û£ºcard_id diseaasestageName

  -59052  

Ϊʲôǰһ¸ö µÄdiseaasestagenameÓÐÖµ£¬ºóÒ»¸ö¾ÍûֵÄØ£¿£¿

---

rownumÊÇÒ»¸öαÁУ¬Èç¹ûÓÐÅÅÐò£¬ËüÊÇÏÈ·ÖÅärownum£¬ÔÙorder by£¬ËùÒÔÒªÏëÏÈorder by£¬ºórownum£¬ÇëÓÃ×Ó²éѯÏÈorder by²Ù×÷
SQL code:
SELECT i.card_id,
(SELECT rownum, m.names
from