Learn T-SQL Recursive Queries | Interactive Course

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

5/14 Single CTE

1. Welcome

2. The Project table

3. The Employee table

4. The Allocation table

5. Single CTE

6. Multiple CTEs

7. Nested CTEs

8. Nested CTEs with a subquery

9. Simple recursive CTEs

10. Complex recursive CTE – trees

11. Complex recursive CTE – graphs

12. UPDATE with CTE

13. INSERT INTO with CTE

14. Congratulations

Good. Let's get started with a single CTE.

For each project, show the ProjectId and the average number of hours employees spend on the project. Name the column AvgHours.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Recursive Queries in MS SQL Server

Instruction

Exercise

Need assistance?