SQL²éѯÏÔʾÎÊÌâ(2) - MS-SQL Server / »ù´¡Àà

ÓÐÒ»¸ö×Ö¶ÎA £¬ÀïÃæÊǾßÌåÊÇÊý×Ö£¬
ÎÒÏëÈÃËû²éѯÏÔʾʱ¼ÓÅÐ¶Ï ±ÈÈç £º0-100 ÏÔʾ³É£º1 £»101-200 ÏÔʾ³É£º2  
ÈçºÎʵÏÖ£¬²»Ê¤¸Ð¼¤£¡£¡£¡

---

ÒýÓÃ

ÓÐÒ»¸ö×Ö¶ÎA £¬ÀïÃæÊǾßÌåÊÇÊý×Ö£¬
ÎÒÏëÈÃËû²éѯÏÔʾʱ¼ÓÅÐ¶Ï ±ÈÈç £º0-100 ÏÔʾ³É£º1 £»101-200 ÏÔʾ³É£º2
ÈçºÎʵÏÖ£¬²»Ê¤¸Ð¼¤£¡£¡£¡

select case when col between 0 and 100 then 1 when col between 100 and 200 then 2 end from tb

---

SQL code:
select case when '0-100' then 1 else 0 end as'col1',
case when '101-200' then 2 else 0 end as 'col2'
from tb

---

SQL code:
select case when col between 0 and 100 then 1
when col between 100 and 200 then 2 end
from tb

---

select *,(select count(1) from tb where right(A,len(A) - charindex('-',A))<=right(t1.A,len(t1.A) - charindex('-',t1.A))) 
from tb t1 join tb t2 on right(t1.A,len(t1.A) - charindex('-',t1.A))+1 = left(t2.A,charindex ('-',t2.A) -1)