我有这样的结果集结构
ID Value Name 1 Oranges Reponse 1 42 Count 2 Apples Reponse 2 65 Count 3 Figs Reponse 3 74 Count
我想谈谈这个：
ID Response Count 1 Oranges 42 2 Apples 65 3 Figs 74
使用sql.有没有办法做到这一点？谢谢！
解决方法
SELECT a.ID,a.Value AS [Response],b.Value AS [Count]
FROM your_table AS a
INNER JOIN your_table AS b
ON a.ID = b.ID
WHERE a.Name = 'Response'
AND b.Name = 'Count'
