Question

sql 怎么根据一个字段的值把数据拆分成多条数据

a b c
A B 4
拆成
a b c
A B 1
A B 2
A B 3
A B 4

Answer 1

可以这样来查询:

1
2
3
4
5
6
7
8
9
10

<a href="https://www.baidu.com/s?wd=select&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLuWnkrANBuH9hPANBuADv0AP8IA3qPjfsn1bkrjKxmLKz0ZNzUjdCIZwsrBtEXh9GuA7EQhF9pywdQhPEUiqkIyN1IA-EUBtkn16zPHbsrjRYrjmLPjcdPHfs" target="_blank" class="baidu-highlight">select</a> s.a01, s.<a href="https://www.baidu.com/s?wd=a02&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLuWnkrANBuH9hPANBuADv0AP8IA3qPjfsn1bkrjKxmLKz0ZNzUjdCIZwsrBtEXh9GuA7EQhF9pywdQhPEUiqkIyN1IA-EUBtkn16zPHbsrjRYrjmLPjcdPHfs" target="_blank" class="baidu-highlight">a02</a>, 1.000 <a href="https://www.baidu.com/s?wd=as&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLuWnkrANBuH9hPANBuADv0AP8IA3qPjfsn1bkrjKxmLKz0ZNzUjdCIZwsrBtEXh9GuA7EQhF9pywdQhPEUiqkIyN1IA-EUBtkn16zPHbsrjRYrjmLPjcdPHfs"target="_blank" class="baidu-highlight">as</a> a03, s.a04
<a href="https://www.baidu.com/s?wd=from&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLuWnkrANBuH9hPANBuADv0AP8IA3qPjfsn1bkrjKxmLKz0ZNzUjdCIZwsrBtEXh9GuA7EQhF9pywdQhPEUiqkIyN1IA-EUBtkn16zPHbsrjRYrjmLPjcdPHfs" target="_blank" class="baidu-highlight">from</a> table_name s,
(
<a href="https://www.baidu.com/s?wd=select&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLuWnkrANBuH9hPANBuADv0AP8IA3qPjfsn1bkrjKxmLKz0ZNzUjdCIZwsrBtEXh9GuA7EQhF9pywdQhPEUiqkIyN1IA-EUBtkn16zPHbsrjRYrjmLPjcdPHfs" target="_blank" class="baidu-highlight">select</a> 1.000 <a href="https://www.baidu.com/s?wd=as&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLuWnkrANBuH9hPANBuADv0AP8IA3qPjfsn1bkrjKxmLKz0ZNzUjdCIZwsrBtEXh9GuA7EQhF9pywdQhPEUiqkIyN1IA-EUBtkn16zPHbsrjRYrjmLPjcdPHfs" target="_blank" class="baidu-highlight">as</a> val
union
<a href="https://www.baidu.com/s?wd=select&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLuWnkrANBuH9hPANBuADv0AP8IA3qPjfsn1bkrjKxmLKz0ZNzUjdCIZwsrBtEXh9GuA7EQhF9pywdQhPEUiqkIyN1IA-EUBtkn16zPHbsrjRYrjmLPjcdPHfs" target="_blank" class="baidu-highlight">select</a> 2.000
union
select 3.000
) c
where s.a03 >= c.val