using distinct keyword in SQl query

Question

I want to retrieve a table which has repeated values in column1, column2 and column3. column 4 has different sets of data corresponding to value in column3. How should I query such a table?

Ex:

District  | City           | Place 
----------|----------------|-------------
bangalore | bangalorerural | indiranagar
bangalore | bangalorerural | jayanagar

I want to display bangalore, bangalorerural once with indiranagar and jayanagar in other rows.

Not sure it can be done into a table but you can get a similar structure by returning xml — Matt
– Matt, Commented Mar 18, 2011 at 10:17
Plese provide desired output. I understand that data provided in the question is table from which you'd like to get data and not the result. If it's the other way around, then provide an example table data. I can't really say whether you'd like to concatenate column3 or something else... — Robert Koritnik
– Robert Koritnik, Commented Mar 18, 2011 at 11:18

adolf garlic · Accepted Answer · 2011-03-18 11:33:17Z

3

UNPIVOT is what you're after

http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=UNPIVOTData

answered Mar 18, 2011 at 11:33

adolf garlic

3,1148 gold badges40 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Andriy M Over a year ago

I understand that the question is vague, but... how can it be about UNPIVOT? What have you deduced is to be unpivoted here?

adolf garlic Over a year ago

Bangalore need to be displayed once. i.e. an UNPIVOT. I'm only going with what I figure the asker is asking. I think they need to clarify by giving an example of the output now I've re-read

Collectives™ on Stack Overflow

using distinct keyword in SQl query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related