Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

SQL Server : aggregation in JOIN statement - Sql Server

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 2, rows affected: 6, absolute service time: 0,2 sec 
edit mode |  history
   id menuadi ustmenuid json_agg
1 1 Ortak Konulu Mansetler NULL [ {"id":"2","menuadi":"Kayseri Deki Bombali Saldirinin Yansimalari","ustmenuid":"1"}, {"id":"3","menuadi":"Sayin Cumhurbaskanimizin Trabzon Daki Açiklamalarinin Yansimalari","ustmenuid":"1"} ]
2 4 Ortak Haberler NULL [ {"id":"5","menuadi":"Sayin Hanimefendinin Trabzonda Sehit Aileleriyle Bir Araya Gelmesinin Yansimalari","ustmenuid":"4"}, {"id":"6","menuadi":"Türk Meslektaslarimizin Yanindayiz","ustmenuid":"4"} ]