一个电视经销商在表Tvtype中维护库存的电视信息,下述()语句能显示价格(iprice)最昂贵的三种电视机的信息(cDiscription)
- A、select top3 cDiscription fromTvtype order by iprice asc
- B、select cDiscription from Tvtype where max(iprice)>3
- C、select top3 cDiscription from Tvtype order by iprice desc
- D、selec tcDiscription max(iprice)from Tvtype order by iprice
正确答案:C
答案解析:有

微信扫一扫手机做题