SQL Server — Window functions

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