Skip to Main Content
Forums

If select query fetches 2 records with 3 columns. I want to make a query which will give output in o

2999661Jul 27 2015 — edited Jul 27 2015

For example.

My Table gives following records.

ServiceSubServiceAddresss
11_AAAASD
11_BBBRTY
22_RRRTYT
22_YYYGHN

For each main service I want both the SubService and Address on the same row.

Output expected

ServiceSubservice1Address1SubService2Address2
11_AAAASD1_BBBRTY
21_BBBTYT2_YYYGHN

Please help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Aug 24 2015
Added on Jul 27 2015
#pivot, #select, #with
1 comment
237 views