一个电视经销商在表Tvtype 中维护库存的Tvs信息,下述哪条语句能显示价格最昂贵的三种电视机的信息?( )
一个电视经销商在表Tvtype 中维护库存的Tvs信息,下述哪条语句能显示价格最昂贵的三种电视机的信息?( )
A. A.A. select top3 cDiscription from Tvtype order by iprice asc
B. B.B. select cDiscription from Tvtype where max(iprice)>3
C. C.C. select top3 cDiscription from Tvtype order by iprice desc
D. D.D. select cDiscription max(iprice) from Tvtype order by iprice