sql µÄ²éѯÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

±ít1

ÁÐ1 ÁÐ2
a 2
b 1
c 3

ÎÒÏ£ÍûÄܸù¾ÝÁÐ2µÄÖµÀ´¾ö¶¨×îºóµÄÏÔʾ 
a 2
a 2
b 1
c 3
c 3
c 3
ÓÐûÓÐʲôºÃµÄ°ì·¨¡£ÄÜͨ¹ýselectÖ±½Ó½â¾öµÄ

---

½èÖúmaster..spt_values

---

ÓÃsql2005µÄwith µÝ¹é

---

SQL code:
select k.*
from kof k join master..spt_values s
on k.col2>=s.number
where s.type='p' and s.number between 1 and (select MAX(col2) from kof)
order by col1
/*
col1 col2
---------- -----------
a 2
a 2
b 1
c 3
c 3
c 3
*/

---

SQL code:
select k.*
from kof k join master..spt_values s
on k.col2>=s.number
where s.type='p' and s.number>0
order by col1
/*
col1 col2
---------- -----------
a 2
a 2
b 1
c 3
c 3
c 3
*/

ÕâÑùÒ²¿ÉÒÔ

---

SQL code:
if not object_id('tb') is null
drop table tb
Go
Create table tb([ÁÐ1] nvarchar(1),[ÁÐ2] int)
Insert tb
select N'a',2 union all
select N'b',1 union all
select N'c',3
Go
Select a.*
from tb a ,master..spt_values b