SQL_Server知识点全集.docVIP

mysql查询语句全集select * from pet --列出指定的列 select name, owner form pet --直接进行算术运算，对字段起别名 select sin(1+2) as sin --where条件 select * from pet where (birth1980 and species=dog) or species=bird --对null的条件 select * from pet where sex is not null --所有名字第四位是n的宠物信息是 select * from pet where owner like ___n% --所有主人名叫gwen或benny的宠物 select * from pet where owner in (gwen , benny) --查询出生日期在90年代是宠物，相当与 = and = select * from pet where birth between 1990 and 1999 --按主人姓名排序，相同的按宠物姓名倒序排列 select * from pet order by owner, name desc --查询性别为公的宠物，按生日倒序排列 select * from pet where sex=m