SQL server 第十章------模糊查询和聚合函数
上机练习1
–查询住址在“山东”的学生姓名、电话、住址。
create table student(
Name nvarchar(100),
Phone nvarchar(100),
Address nvarchar(100)
)
go
insert student(Name,Phone,Address)
select ‘张三’,‘132321123’,‘山东省长江路’ union
select ‘李四’,‘172178718’,‘山东省安宁市’
go
select*
from student
where Address like ‘山东省%’
go
–查询名称中含有“数据库”字样的科目名称、学时及所属年级,并按年级由低到高显示。
create table Grade(
WorkName nvarchar(100),
WorkTime int,
WordID int
)
go
insert Grade(WorkName,WorkTime,WordID)
select ‘sql sever 数据库应用’,‘50’,‘1’ union
select ‘my sql 数据库应用’,‘80’,‘2’ union
select ‘t-sql 数据库应用’,‘70’,‘3’
go
select WorkName as 科目名称,
WorkTime as 课时,
WordID as 年级
from Grade
where WorkName like ‘%数据库%’
order by WordID desc
go
–查询