The number of values in the SQL Server statistics field is within certain ranges

There is a table test as follows:

Create Table  intIdentity(1,1primarykeyint  )

Insert data:

Insert  intoTest (NUM)Values(1);Insert  intoTest (NUM)Values(2);Insert  intoTest (NUM)Values(8);Insert  intoTest (NUM)Values( the);Insert  intoTest (NUM)Values( A);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values(5);Insert  intoTest (NUM)Values(6);Insert  intoTest (NUM)Values(7);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values(9);Insert  intoTest (NUM)Values(Ten);Insert  intoTest (NUM)Values( One);Insert  intoTest (NUM)Values( A);Insert  intoTest (NUM)Values( +);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values(3);Insert  intoTest (NUM)Values(4);Insert  intoTest (NUM)Values( +);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values( -);Insert  intoTest (NUM)Values( -);

View Code

Question: Please use an SQL statement query to count the number of num in the 1~6, 10~17, 19~20 three ranges, respectively?

The solution is as follows:

Select COUNT( Case  whenNumbetween 1  and6 Then 1 End) as [1-6],COUNT( Case  whenNumbetween Ten  and  -  Then 2 End) as [10-17],COUNT( Case  whenNumbetween  +  and  -  Then 3 End) as [19-20] fromTest

If the problem is to ask the 6~10,11~15, the number of multiples (regular), then you can write:

Select COUNT (*fromgroup by num/5

The number of values in the SQL Server statistics field is within certain ranges