Except 1--Select the second min item. 2selectmin(scroe) 3from 4( 5select scroe 6from ta 7except 8selectmin(scroe) 9from ta 10) as A 11 12--Select the second max item. 13selectmax(scroe) 14from 15( 16select scroe 17from ta 18except 19selectmax(scroe) 20from ta 21) as A 22 23