Wednesday, May 5, 2021

Find the Subtasks That Did Not Execute Leetcode

 with recursive CTE as

(

SELECT task_id,subtasks_count,1 as result FROM Tasks

UNION ALL

SELECT CTE.task_id,subtasks_count,result+1 FROM CTE where result<subtasks_count

)

SELECT 

CTE.task_id,CTE.result FROM CTE LEFT JOIN Executed e

on e.task_id=CTE.task_id and e.subtask_id= CTE.result

where e.subtask_id is null

order by task_id,result

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Find the Subtasks That Did Not Execute Leetcode

 with recursive CTE as ( SELECT task_id,subtasks_count,1 as result FROM Tasks UNION ALL SELECT CTE.task_id,subtasks_count,result+1 FROM CTE ...

  • Median of numbers
    create Table numbers (number int,frequency int); insert into numbers values (1,2); insert into numbers values (4,1); insert into numbers val...
  • Median Employee Salary
     Create table If Not Exists Employee (Id int, Company varchar(255), Salary int); Truncate table Employee; insert into Employee (Id, Company,...
  • Find the Subtasks That Did Not Execute Leetcode
     with recursive CTE as ( SELECT task_id,subtasks_count,1 as result FROM Tasks UNION ALL SELECT CTE.task_id,subtasks_count,result+1 FROM CTE ...