SQL Puzzle: SQL Advance Query – Find maximum consecutive wins for team India

Check the below input data and require output data to find maximum consecutive wins for team India. Input Data: [crayon-6a24061f3d567225645795/] Expected output: [crayon-6a24061f3d56a574505995/] Create a table with sample data: [crayon-6a24061f3d56b138638136/] Solution: [crayon-6a24061f3d56c675026915/] Please try the different solutions for this puzzle and share it via comment... Oct 18, 2017Anvesh Patel

October 18, 2017 Uncategorized

October 17, 2017

SQL Puzzle: SQL Advance Query – Concat repeated String with their Count

October 16, 2017

SQL Puzzle: SQL Advance Query – If holiday on joining day, change joining date

October 15, 2017

SQL Puzzle: SQL Advance Query – Find count of value from multiple columns

October 14, 2017

SQL Puzzle: SQL Advance Query – Skip the first set of Zeros

October 13, 2017

SQL Puzzle: SQL Advance Query – Find second highest salary for each department

October 12, 2017

SQL Puzzle: SQL Advance Query – Find number of days of the Month of any date

October 11, 2017

SQL Puzzle: SQL Advance Query – Find number the first day of Quarter of Year

October 10, 2017

SQL Puzzle: SQL Advance Query – Solve Date Overlapping Problem

October 9, 2017

SQL Puzzle: SQL Advance Query – Partition Employee Table in Three parts

Older posts Newer posts

About Me!