SQL Puzzle: SQL Advance Query – Find date range for same Market Rank

Check the below input data and require output data to find the start date and end date range for the same market rank and if market rank change, only generates a new range row. Input data: [crayon-6a23f4403b320885706999/] Expected output: [crayon-6a23f4403b322917906245/] Create a table with sample data: [crayon-6a23f4403b323664223445/] Solution 1: [crayon-6a23f4403b324305948516/] Solution 2: [crayon-6a23f4403b325902207972/] Oct 28, […]

October 28, 2017 SQL Puzzle