mysql查詢最大值:mysql查詢最大值記錄[朗讀]

最大值:selectmax(num)fromtable第二大值:selectmax(num)fromtablewherenumnotin(selectmax(num)fromtable)第三大值:selectmax(num)fromtablewherenumnotin(selectmax(num)fromtablewherenumnotin(selectmax(num)fromtable))最小值:selectmin(num)fromtable。