sql²éѯÅжÏÌõ¼þÎÊÌâ

±í½á¹¹£ºtable name:T1
FID int  ×ÔÔö
FPYear  int 4
FPMonth int 4
FFlag  int 4

±íÊý¾Ý£º
FID        FPYear        FPMonth  FFlag
1          2009          12        1
2          2010            1        1
3          2010            2        0
4          2010            3        0

ÎÊÌ⣺
ÎÒÈçºÎÅжÏÎÒ²éѯÄêÔ²鵽µÄÊý¾Ý¶ÔÓ¦FFlagÊÇ·ñÊÇ×îºóÒ»¸öΪ¡°1¡±µÄ¼Ç¼£¿£¿
select  FFlag from  T1 where  FPYear='2010' and FPMonth='1'

---

SQL code:
select
max(id)
from
(
select
*,id=row_number()over(partition by fflag order by fflg)
from
tb
)
where
FPYear='2010' and FPMonth='1'

---

SQL code:


--ÕâÑù£¿

select top 1 FFlag from T1 where FPYear=2010 and FPMonth=1 order by fid desc

---

SQL code

---

Code highlighti