SQL 语句

select distinct t2.Items,t2.Number,t2.orderID,t2.Title,t2.notice,t2.Author,t2.Site,t2.MainBody,t2.YNUPDATE,t2.YNVIEW,t2.CreateTime
 from  [C_Notice] as t2  where  t2.Site='FQ'  and Items=N'CS-房屋租赁合同' and orderID=(SELECT  max(cast(orderID as int)) from [C_Notice] where Site='FQ' and Items=N'CS-房屋租赁合同' )