如何显示SQL表中最贵的产品名称和产品价格~~~~~~~~~~~~~深夜求助~~望好心人路过帮忙解答3Q~3Q~
想得到Products表中最贵的产品名称和产品价格.
Select top1 Productname,Price From Products ORDER BY price
Select Productname, max(Price) from products
select Productname,max(price) from Products Group BY Productname
select Productname,Price From products where price=(Select max(Price) from products)
请说出以上三句哪儿对哪儿错..为啥错了...谢谢赐教!