How to Use Join and String_agg in Microsoft SQL Server

8 min readMar 6, 2021

--

Photo by MI PHAM on Unsplash

In this article, we’ll look at how to use join on more than two tables and aggregate the result using the function STRING_AGG() in Microsoft SQL Server.

If you don’t know about Microsoft SQL Server, I’ll briefly explain to you what it is.

😃

What is Microsoft SQL Server?

Thanoshan MV

Written by Thanoshan MV

My notes, findings, thoughts and investigations.

Recommended from Medium

The PyCoach
in
Artificial Corner

You’re Using ChatGPT Wrong! Here’s How to Be Ahead of 99% of ChatGPT Users

Master ChatGPT by learning prompt engineering.

7 min readMar 17

--

Love Sharma
in
Dev Genius

System Design Blueprint: The Ultimate Guide

Developing a robust, scalable, and efficient system can be daunting. However, understanding the key concepts and components can make the…

9 min readApr 20

--

Lists

Staff Picks

331 stories84 saves

Stories to Help You Level-Up at Work

19 stories53 saves

Self-Improvement 101

20 stories107 saves

Productivity 101

20 stories117 saves

Alexander Nguyen
in
Level Up Coding

Why I Keep Failing Candidates During Google Interviews…

They don’t meet the bar.

4 min readApr 13

--

HKN MZ
in
Towards Dev

SQL Exercises with Questions and Solutions

Hi everyone, with this article we will do some Sql, T-Sql exercises.

8 min readDec 29, 2022

--

Aleid ter Weel
in
Better Advice

10 Things To Do In The Evening Instead Of Watching Netflix

Device-free habits to increase your productivity and happiness.

5 min readFeb 15, 2022

--

Mondoa

SQL Query Optimization

SQL (Structured Query Language) is the lingua franca of the database world. It’s a powerful language that allows you to query and…

6 min readMar 12

--

See more recommendations

Help
Status
Writers
Blog
Careers
Privacy
Terms
About
Text to speech