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-673b95cf5a6d5498677027/] Expected output: [crayon-673b95cf5a6e3348694121/] Create a table with sample data: [crayon-673b95cf5a6e5402692724/] Solution 1: [crayon-673b95cf5a6e7275978230/] Solution 2: [crayon-673b95cf5a6f2425428546/] Oct 28, […]

October 28, 2017 2 SQL Puzzle

October 27, 2017 1

SQL Puzzle: SQL Advance Query – Count the total Working days from the given dates

October 26, 2017 4

SQL Puzzle: SQL Advance Query – To Swap the values in the Table

October 25, 2017 3

SQL Puzzle: SQL Advance Query – Generate the report on Missing Year – Month data

October 24, 2017 4

SQL Puzzle: SQL Advance Query – Find the average shared salary by each department

October 23, 2017 2

SQL Puzzle: SQL Advance Query – Find the date of all third Sunday for Year 2017

October 22, 2017 3

SQL Puzzle: SQL Advance Query – Check number is an Integer or not an Integer

October 21, 2017 5

SQL Puzzle: SQL Advance Query – Split the String and generate count of Each part

October 20, 2017 1

SQL Puzzle: SQL Advance Query – Use STUFF() and form the aggregate of columns

October 19, 2017 4

SQL Puzzle: SQL Advance Query – Group and Count of Consecutive flags

Older posts Newer posts

About Me!