怎么样:
SELECt TOP 5 Date, Val FROM (SELECt Date, A as Val FROM T UNIOn ALL SELECt Date, B FROM T UNIOn ALL SELECt DATE, C FROM T) AS xORDER BY x.Val DESC

怎么样:
SELECt TOP 5 Date, Val FROM (SELECt Date, A as Val FROM T UNIOn ALL SELECt Date, B FROM T UNIOn ALL SELECt DATE, C FROM T) AS xORDER BY x.Val DESC