关于SQL 2008中的查询问题 [英] problem about query in sql 2008

问题描述

该表有两列，其中9行类似于

the table has two columns in there 9 row that like

---------------------------
dist           tail
--------------------------
pune          daund
Ahmednagar    karjat
Ahmednagar    parner
Ahmednagar    shrigonda
pune          baramati
pune          purandar
satara        karad
satara        pacgani
satara        mahableshowar
-------------------------  

*如何以类似于以下表格格式的格式对表格中的记录进行排序

*how to sort records in the table in the format like below table format

----------------------------------------------------------------

dist1  tail1       dist2       tail2       dist3      tail3   
----------------------------------------------------------------
pune   daund     Ahmednagar   karjat       satara     karad
pune   baramati  Ahmednagar   parner       satara     pacgani
pune  baramati   Ahmednagar   shrigonda     satara    mahableshowar
-------------------------------------------------------------------  

给我一个答案-----------

give me ans-----------

推荐答案

您无法在SQL查询中执行此操作.

You can''t do this in a SQL query.

这篇关于关于SQL 2008中的查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！