Skip to Main Content

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
Post Details
Added on Jul 27 2015
1 comment
232 views