sql学习随笔2----计算列查询，条件查询，范围查询

== 未特别说明则为SQL Server环境==

计算列查询

连接列值

select name + cat_name as ‘品牌信息’ from table1；

查询中使用计算列

select goods_id as "商品ID",goods_name as "商品名称",(shop_price-cost_price) as "销售利润" from goods;
/*其中+，*，/,%使用类似*/

查询中使用表达式

select goods_id as 商品ID,goods_name as  商品名称,cost_price + 50 as 进价加50 from goods；

条件查询

where子句: select name from table where <条件表达式>

select * fro goods where goods_id=100;
/*对于>,<,>=,<=,!>,!<,!=和<>也适用*/

范围查询

查询两个值之间的数据

***between …and…语句：***大于第一个数小于第二个数,且该语句位于where后

select good_id as 商品id from goods where price between 1000 and 2000;

查询不在两个数之间的数据

select good_id as 商品id from goods where price not between 1000 and 2000;