select * from dbo.TeacherInfo where TeacherAddress='湖南'
go
select * from dbo.TeacherInfo order by TeacherSalary desc,id desc
go
转载于:https://blog.51cto.com/goot2012/959032
转载于:https://blog.51cto.com/goot2012/959032