题海让大学四年没有难题
白天模式登陆

题目详情

单选题 从货物订单数据表(order)中查询出其中订单金额(order_price)在1000和5000之间的订单的详细信息,并按照订单金额(order_price)升序排列.正确的语句是( )

A. select * from order where order_price between 1000 and 5000 order by order_price DESC

B. select * from order where 1000<order_price<5000 order by order_price DESC

C. select * from order where 1000<order_price<5000 order by order_price ASC

D. select * from order where order_price between 1000 and 5000 order by order_price ASC

学科:SQLServer数据库技术及应用

时间:2024-12-27 11:39:17

Copyright © 2022 津ICP备2021001502号