SQLserver条件查询语句

1、打开SQLserver数据库

2、创建一张表，插入数据

create database TC

go

use TC

go

create table tb

(

id int,

name varchar(20),

sex char(2),

adress varchar(20)

) 

go

insert into tb values(1,'张三','男','云南')

insert into tb values(2,'李钰','女','韩国')

insert into tb values(3,'王五','男','海南')

insert into tb values(4,'李莉','女','四川')

insert into tb values(5,'钱七','男','吉林')

insert into tb values(6,'孙莉','女','广东')

3、--按照名字查找

select * from tb where name='孙莉'

--按照性别查找

select * from tb where sex='女'

--按照居住地查找

select * from tb where adress='吉林'

--按照id查找

select * from tb where id=1