SQLserver条件查询语句

1、打开SQLserver数据库

2、创建一张表，插入数据create database TCgouse TCgocreate table tb(id int,name varchar(20),sex char(2),adress varchar(20))goinsert 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='孙莉'--按照性别查找se造婷用痃lect * from tb where sex='女'--按照居住地查找select * from tb where adress='吉林'--按照id查找select * from tb where id=1