下面SQL语句都使用了聚合函数，其中选项（）存在错误。
- A、SELECT MIN(au_lname) FROM authors
- B、SELECT ADD(ytd_sales+1) FROM titles
- C、SELECT type,MAX(price) FROM titles GROUP BY type ORDER BY type
- D、SELECT COUNT(*) ,avg(price) FROM titles WHERE advance > $1000
正确答案:B
答案解析:有
微信扫一扫手机做题