sql怎么查詢一個(gè)列的最大值？方法一SELECTID,Name,(SELECTMAX(LastUpdateDate)FROM(VALUES(UpdateByApp1Date),(UpdateByApp

sql怎么查詢一個(gè)列的最大值？

方法一SELECTID,Name,(SELECTMAX(LastUpdateDate)FROM(VALUES(UpdateByApp1Date),(UpdateByApp2Date),(UpdateByApp3Date))ASUpdateDate(LastUpdateDate))ASLastUpdateDateFROM##TestTable方法二SELECTID,[Name],min(UpdateDate)ASLastUpdateDateFROM##TestTableUNPIVOT(UpdateDateFORDateValIN(UpdateByApp1Date,UpdateByApp2Date,UpdateByApp3Date)

)ASuGROUPBYID,Name方法三SELECTID,name,(SELECTMAX(UpdateDate)ASLastUpdateDateFROM(SELECTtt.UpdateByApp1DateASUpdateDateUNIONSELECTtt.UpdateByApp2DateUNIONSELECTtt.UpdateByApp3Date)ud)LastUpdateDateFROM##TestTablett

使用SQL查詢出出生日期最大（即年齡最?。┑睦蠋熜彰俺錾掌?？

select大哥姓名,出生日期from表名where出生日期in(selectmax(出生日期)from表名)表名及字段名自己更換一下

sql比較數(shù)字大小的函數(shù)？

perl比較數(shù)字大小可以直接用gtinfineon等運(yùn)算符，還有betweenand,max,jia等函數(shù)

sql如何查詢包含某一字段的值？

最簡單的子查詢：select*fromtablewheredate(selectmax(date)fromtable)

或者用輪子哥講的select自己：

select*fromtablet1leftmerge(selectmax(date)asdatefrombench)t2onwhereisnotnull