Question

sas 如何用sql语句查询符合条件的最大值

Answer 1

--测试数据createtablebus_table(idintIDENTITY(1,1)NOTNULL,ROUTEIDvarchar(10)NULL,BUSIDvarchar(10)NULL,DATETIMEDATETIMENULL)goinsertintobus_tableselect'1','1','2011-05-0808:59:46'unionallselect'1','2','2011-05-0809:59:46'unionallselect'18','1','2011-05-0808:59:46'unionallselect'18','1','2011-05-0813:59:46'unionallselect'18','2','2011-05-0811:59:46'unionallselect'18','2','2011-05-0814:19:46'unionallselect'18','3','2011-05-0808:59:46'unionallselect'18','3','2011-05-0813:59:46'unionallselect'18','4','2011-05-0811:59:46'unionallselect'18','5','2011-05-0814:19:46'unionallselect'18','3','2011-05-0813:59:46'unionallselect'18','5','2011-05-0819:19:46'go--SQL语句一select*frombus_tableawhereidin(selecttop1idfrombus_tablewherebusid=a.busidandROUTEID=a.ROUTEIDandDATETIME<getdate()andROUTEID='18'orderbyDATETIMEdesc)ORDERBYROUTEID,busid,DATETIME