Azure / Azure/usql

U-SQL subquery question

Open
#121 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
231
Forks
666
PR merge metrics
No merged PRs in 30d

Description

Guys I'm having a hard time trying to figure out how to do the next subquery

```sql
declare @ventas as table(
semana int,
existencia int
);

declare @semanas as table(
semana int
);

insert into @ventas
values (1, 10),(3, 9),(5, 8);

insert into @semanas
values (1), (2), (3), (4), (5);

select s.semana,
isnull(v.existencia,
-- **** this part
(select top 1 existencia from @ventas where semana < s.semana order by semana desc) ) as existencia
from @semanas s
left outer join @ventas v on v.semana = s.semana

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.