SQL查询的经验分享(范围)

时　间:2015-01-07 17:25:19
作　者:libin   ID：27263  城市：无锡
摘　要:SQL查询的经验分享
正　文:

查询的经验分享

1,Partition(字段,开始值,最高值,区间最大值)

Select DISTINCTROW Partition([奖金],1,10000,500) AS 范围,
Count(test.[姓名]) AS 人数
FROM test
GROUP BY Partition([奖金],1,10000,500);
-----------------------------------------------

2,in 的应用

Select *
FROM test
Where [姓名] in (select [姓名] 
FROM test2 where [可用]=true);



Select *
FROM test
Where [姓名] in ("vicky","jenny","jake");
------------------------------------------------

3,Between 的应用

Select *
FROM test
Where [奖金] between 1 and 500
orDER BY [奖金];
------------------------------------------------

4,大于小于的应用

Select *
FROM test
Where [奖金] >=500
orDER BY [奖金];