SQL Server | sql server interview questions and answers | Total by multiple tables | Part 39

Опубликовано: 06 Декабрь 2019
на канале: SS UNITECH

2,924

Find Us On YouTube- "Subscribe Channel to watch Database related videos"    / @ssunitech6890

For SQL Quiz-
   • sql server : Interview Quiz | sql ser...

Find Us On FaceBook-
  / ss-unitech-187705388674384

Query---

CREATE TABLE PART39_A
(
ID INT,
SALARY INT
)

CREATE TABLE PART39_B
(
ID INT,
SALARY INT
)

CREATE TABLE PART39_C
(
ID INT,
SALARY INT
)

INSERT INTO PART39_A VALUES(1,100),(2,200),(3,300),(4,400)
INSERT INTO PART39_B VALUES(1,100),(2,200),(3,300)
INSERT INTO PART39_C VALUES(1,100),(2,200),(3,300),(5,500)

select * from PART39_A
select * from PART39_B
select * from PART39_C
---method 1
;with cte
as
(
select * from PART39_A
union all
select * from PART39_B
union all
select * from PART39_C
)
select id,sum(SALARY) as sal
from cte
group by ID

--Method 2

select coalesce(a.id,b.id,c.id) as id,isnull(a.SALARY,0)+ISNULL(b.salary,0)+isnull(c.salary,0) as sal
from PART39_A as a
full join PART39_B as b on a.ID=b.ID
full join PART39_C as c on a.ID=c.ID

Смотрите видео SQL Server | sql server interview questions and answers | Total by multiple tables | Part 39 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь SS UNITECH 06 Декабрь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,92 раз и оно понравилось 5 людям.