SQL简单的查询语句.?

来源：百度知道 编辑：UC知道 时间：2024/06/03 22:02:16
--1 查询所有入学入学日期在2001-2005并且年龄大于21岁的学生编号，姓名要求以中文显

--2 查询入学年份是2005并且地址中含有株的所有学生

这两句要怎么写啊.？ 有谁可以帮我写下啊1. ?
1 查询入学年份是2005并且地址中含有株的所有学生
select *
from dbo.CeshiTable
where DateTime=2005 and Address='%株%'

结果是：
(0 行受影响) ，请问哪里有问题.?

select *
from dbo.CeshiTable
where DateTime=2005 and Address like '%株%'

不要用等号，等号表示完全匹配，like表示模糊查询

select student_ID as 学生编号 from student where in_date between(2001,2005)

select * from student where address like %'株'%

select sno,sname
from student
where intertime between 2001 and 2005 and
age>21;

select *
from student
where intertime=2005 and
adress="%株%"

正确的,只是没有符合条件的查询结果的意思.

1、select * from [tablename] where datetime between 2001 and 2005 and age > 21 学生编号和中文姓名视具体表结构而定。
2、select * from dbo.CeshiTable where DateTime=2005 and Address like '%株%' 不能用=，使用 like。

1 select sno,sname from student
where entertime between 2001 and 2005 and age>21

2 select * from dbo.CeshiTable where DateTime=2005 and Address like '%株%'

select * from dbo.CeshiTable
where DateTime between(2001,2005) and Add