单项选择题
A.select *from 表名where age in (select avg(age)from 表名);B.select *from 表名where age>(select count(age)from 表名);C.select *from 表名where age>(select avg(age)from 表名);D.select *from 表名where avg(age)>(select avg(age)from 表名);
如果需要查询出两表之间的共同数据应该用什么连接方法?()A.外连接B.内连接C.左连接D.右连接
单项选择题如果需要查询出两表之间的共同数据应该用什么连接方法?()
A.外连接B.内连接C.左连接D.右连接
当数据量过大时,查询出前三行信息,下列哪个是正确的?()A.select *from students whe...
单项选择题当数据量过大时,查询出前三行信息,下列哪个是正确的?()
A.select *from students where gender=1limit 1,3;B.select *from students where gender=1limit 0,3;C.select *from students where gender=1limit 1,4;D.select *from students having gender=1limit 0,3;
下列哪个空判断是正确的?()A.select *from students where height is n...
单项选择题下列哪个空判断是正确的?()
A.select *from students where height is nullB.select *from students where height=nullC.select height is null from studentsD.select height=null from students