SQL Server — CTEs

1 MySQL SELECT with LIMIT Easy 2 T-SQL CTE ranked earners #1 Hard 3 T-SQL CTE ranked earners #2 Medium 4 T-SQL CTE ranked earners #3 Easy 5 T-SQL CTE ranked earners #4 Medium 6 T-SQL CTE ranked earners #5 Hard 7 T-SQL CTE ranked earners #6 Medium 8 T-SQL CTE ranked earners #7 Easy 9 T-SQL CTE ranked earners #8 Medium 10 T-SQL CTE ranked earners #9 Hard 11 T-SQL CTE ranked earners #10 Medium 12 T-SQL CTE ranked earners #11 Easy 13 T-SQL CTE ranked earners #12 Medium 14 T-SQL CTE ranked earners #13 Hard 15 T-SQL CTE ranked earners #14 Medium 16 T-SQL CTE ranked earners #15 Easy 17 T-SQL CTE ranked earners #16 Medium 18 T-SQL CTE ranked earners #17 Hard 19 T-SQL CTE ranked earners #18 Medium 20 T-SQL CTE ranked earners #19 Easy 21 T-SQL CTE ranked earners #20 Medium 22 T-SQL CTE ranked earners #21 Hard 23 T-SQL CTE ranked earners #22 Medium 24 T-SQL CTE ranked earners #23 Easy 25 T-SQL CTE ranked earners #24 Medium 26 T-SQL CTE ranked earners #25 Hard 27 T-SQL CTE ranked earners #26 Medium 28 T-SQL CTE ranked earners #27 Easy 29 T-SQL CTE ranked earners #28 Medium 30 T-SQL CTE ranked earners #29 Hard 31 T-SQL CTE ranked earners #30 Medium 32 T-SQL CTE ranked earners #31 Easy 33 T-SQL CTE ranked earners #32 Medium 34 T-SQL CTE ranked earners #33 Hard 35 T-SQL CTE ranked earners #34 Medium 36 T-SQL CTE ranked earners #35 Easy 37 T-SQL CTE ranked earners #36 Medium 38 T-SQL CTE ranked earners #37 Hard 39 T-SQL CTE ranked earners #38 Medium 40 T-SQL CTE ranked earners #39 Easy 41 T-SQL CTE ranked earners #40 Medium 42 T-SQL CTE ranked earners #41 Hard 43 T-SQL CTE ranked earners #42 Medium 44 T-SQL CTE ranked earners #43 Easy 45 T-SQL CTE ranked earners #44 Medium 46 T-SQL CTE ranked earners #45 Hard 47 T-SQL CTE ranked earners #46 Medium 48 T-SQL CTE ranked earners #47 Easy 49 T-SQL CTE ranked earners #48 Medium 50 T-SQL CTE ranked earners #49 Hard