在SQL Server数据库中，有一个产品表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 from products order by price DESC

正确答案：SELECT productname,price from products order by price ASC；SELECT productname,price from products order by price