A.外连接B.内连接C.左连接D.右连接
单项选择题当数据量过大时,查询出前三行信息,下列哪个是正确的?()
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 nullB.select *from students where height=nullC.select height is null from studentsD.select height=null from students
单项选择题下列是范围查询函数的是()。
A.likeB.%C.inD.between...in...
单项选择题将年龄按升序排序的前提下,身高按降序排序,下列正确的语句是()。
A.select *from students order by age desc,height descB.select *from students order age asc,height descC.select *from students order by age desc,height ascD.select *from students order by age asc,height desc
单项选择题删除表数据应该使用哪种语句格式?()
A.delete from 表名 where 条件B.delete table from 表名 where 条件C.delete from table 表名 where 条件D.delete * from 表名 where 条件