当前位置:百科知识 > 工学问答B

问题描述:

[多选] 在SQLServer数据库(排序规则为默认值)中,有一个产品表products,你想按照价格从小到大的顺序显示所有产品的名称(productname)和价格(price),可以实现该功能的T-SQL语句是()
A.SELECT productname,price from products order by price ASC B.SELECT productname,price from products order by price DESC C.SELECT productname,price from products order by price D.SELECT productname anprice from products order by price DESC
参考答案:查看
答案解析:
☆收藏

随机题目