select查询

select * from dbo.TeacherInfo where TeacherAddress='湖南'

go

 

select * from dbo.TeacherInfo order by TeacherSalary desc,id desc

go

转载于:https://blog.51cto.com/goot2012/959032