题目详情
单选题 从货物订单数据表(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
相关题目
相关作业