• 2022-05-29 问题

    统计各系男生人数,最准确的SQL语句是(<br/>)。 A: SELECT<br/>COUNT(*) FROM stduents GROUP BY d_no WHERE sex='男' B: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>GROUP BY d_no C: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>ORDER BY d_no D: SELECT<br/>COUNT(*) FROM students HAVING sex='男'<br/>GROUP BY d_no

    统计各系男生人数,最准确的SQL语句是(<br/>)。 A: SELECT<br/>COUNT(*) FROM stduents GROUP BY d_no WHERE sex='男' B: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>GROUP BY d_no C: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>ORDER BY d_no D: SELECT<br/>COUNT(*) FROM students HAVING sex='男'<br/>GROUP BY d_no

  • 1