以下______语句查询表student中第3条到第10条记录 。
A: SELECT * FROM student LIMIT 2,8;
B: SELECT * FROM student LIMIT 2,9;
C: SELECT * FROM student LIMIT 3,10;
D: SELECT * FROM student LIMIT 3,9;
A: SELECT * FROM student LIMIT 2,8;
B: SELECT * FROM student LIMIT 2,9;
C: SELECT * FROM student LIMIT 3,10;
D: SELECT * FROM student LIMIT 3,9;
举一反三
- Select * from student limit 10是指查找student表中的所有记录。
- 下面查询语句中哪条查询语句会查询出所有包含"李"的数据？ A: select * from student where name limit‘%李%’ B: select * from student where name =‘%李%’ C: select * from student where name like‘%李%’ D: select * from student where name in‘%李%’
- 下面用于查询student表中id值在1,2,3范围内的记录的SQL语句是（ ）。 A: SELECT * FROM student WHERE id=1,2,3; B: SELECT * FROM student WHERE (id=1,id=2,id=3); C: SELECT * FROM student WHERE id in (1,2,3); D: SELECT * FROM student WHERE id in 1,2,3;
- MySQL数据库中查询前10条记录的SQL语句是()。 A: select top 10 from table B: select * from table limit 10 C: select * from table limit 1, 10 D: select * from table limit 0, 10
- 下面对于“SELECT * FROM student LIMIT 4;”语句的描述，正确的是