假设sales表用于存储销售信息,sname列为销售人员姓名,smoney列为销售额。现在需要查询最大一笔销售额是多少,则正确的查询语句是( )
A.
select max(smoney) from sales where max(smoney)>0
B.
select sname,max(smoney) from sales where count(sname)>0
C.
select sname,max(smoney) from sales group by sname,smoney
D.
select max(smoney) from sales