以下查询语句中各子句顺序使用正确的有( )A.Select sdept,count(sno) From student Where sname like ‘王%’ Group by ssex ,sdept Having ssex='女' Order by sdept DescB.Select sdept,count(sno) From studentC.Select sdept,count(sno) Where sname like ‘王%’D.Select sdept,count(sno) From student Group by ssex ,sdept
以下查询语句中各子句顺序使用正确的有( )
A、Select sdept,count(sno) From student Where sname like ‘王%’ Group by ssex ,sdept Having ssex='女' Order by sdept Desc
B、Select sdept,count(sno) From student
C、Select sdept,count(sno) Where sname like ‘王%’
D、Select sdept,count(sno) From student Group by ssex ,sdept
发布时间:2024-11-03 23:10:45