不错的面试题
表table1:
┍--------------------------┐
| ID | name |
|--------------------------|
| 1 | A |
| 2 | B |
| 3 | AE |
| 4 | CD |
| 5 | BW |
| 6 | CT |
| 7 | EN |
| 8 | AY |
| . | . |
| . | . |
| . | . |
查询结果是:
┍--------------------------┐
| ID | name |
|--------------------------|
| 1 | A,AE,AY··· |
| 2 | B,BW··· |
| 3 | CD,CT··· |
| 4 | EN··· |
| . | . |
| . | . |
| . | . |
└--------------------------┚
Code
Code
┍--------------------------┐
| ID | name |
|--------------------------|
| 1 | A |
| 2 | B |
| 3 | AE |
| 4 | CD |
| 5 | BW |
| 6 | CT |
| 7 | EN |
| 8 | AY |
| . | . |
| . | . |
| . | . |
查询结果是:
┍--------------------------┐
| ID | name |
|--------------------------|
| 1 | A,AE,AY··· |
| 2 | B,BW··· |
| 3 | CD,CT··· |
| 4 | EN··· |
| . | . |
| . | . |
| . | . |
└--------------------------┚
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
如果
create TABLE t (ID INT,[name] VARCHAR(2))
INSERT INTO T
SELECT 1,'A' UNION ALL
SELECT 1,'B' UNION ALL
SELECT 1,'AE' UNION ALL
SELECT 1,'CD' UNION ALL
SELECT 2,'BW' UNION ALL
SELECT 2,'CT' UNION ALL
SELECT 2,'EN' UNION ALL
SELECT 2,'AY'
结果为
id
----------- ----------------------------
1 A,B,AE,CD
2 BW,CT,EN,AY
(2 行受影响)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
本人在长沙, 有工作可以加我QQ4658276