sql 取最大的id 的内容

SELECT *  FROM dbo.Ys_CloseOPen AS a INNER JOIN
             dbo.Ysmx_CloseOpen AS b ON a.TaskID = b.TaskID
where  a.iyear = '2012' and a.imonth = '2' and

a.taskid = (select max(TaskID) from dbo.Ys_CloseOPen where iyear='2012' and imonth='2')

 

 

 

SELECT    b.CompanyID as CompayID, a.iYear, a.iMonth,b.Itemcode as ItemName, b.AfterStatus
FROM         dbo.Ys_CloseOPen AS a INNER JOIN
                      dbo.Ysmx_CloseOpen AS b ON a.TaskID = b.TaskID
where  a.Flag = 1
group by a.iyear, a.imonth ,a.taskid, a.Flag,
b.CompanyID , a.iYear, a.iMonth,b.Itemcode , b.AfterStatus having  a.taskid in    ---每一个类型的最大id值

(select max(taskid) from Ys_CloseOPen c
group by c.iyear, c.imonth  )