Need a query [message #251746] |
Mon, 16 July 2007 08:39  |
subbu_tce
Messages: 98 Registered: July 2007 Location: pune
|
Member |
|
|
Am having a table called abc which contains 2 columns called x number, y char(1) with data as follows
x y
1 b
1 a
1 l
2 b
2 a
2 j
2 a
2 j
I need a output as
x y
1 bal
2 bajaj
|
|
|
Re: Need a query [message #251749 is a reply to message #251746] |
Mon, 16 July 2007 09:09   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
You will need a 3rd column in the table that specifies which order the rows are to be returned in.
Other than that, do a search for 'Pivot'
|
|
|
|