如果有一个students表，包含id、name、grade列，如何查询成绩（grade）在 80 - 90 ...

测试积点老人 · 发表于 2024-11-7 09:39:04

如果有一个students表，包含id、name、grade列，如何查询成绩（grade）在 80 - 90 之间的学生姓名？

游客，如果您要查看本帖隐藏内容请回复

oliver.tang · 发表于 2024-11-8 09:16:38

select id,name,grade from students where grade between 80 and 90

kallinr · 发表于 2024-11-8 09:17:18

SELECT name FROM students WHERE grade >= 80 AND grade <= 90;

海海豚 · 发表于 2024-11-8 10:53:48

select id,name,grade from students where grade between 80 and 90

jingzizx · 发表于 2024-11-8 11:27:12

select id,name,grade from students where grade between 80 and 90

你好浮戈 · 发表于 2024-11-8 13:13:45

select id,name,grade from students where grade between 80 and 90

litingting0214 · 发表于 2024-11-8 13:53:26

select id,name,grade from students where grade between 80 and 90

		自动登录	找回密码
密码			(注-册)加入51Testing

站长推荐 /1