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-673bb7fe4a8ce689035712/] Expected output: [crayon-673bb7fe4a8d9857399013/] Create a table with sample data: [crayon-673bb7fe4a8db950014774/] Solution: [crayon-673bb7fe4a8dd907072662/] Please try the different solutions for this puzzle and share it via comment... Oct 18, 2017Anvesh Patel

October 18, 2017 1 Uncategorized

October 17, 2017 1

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

October 16, 2017 1

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

October 15, 2017 2

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

October 14, 2017 4

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

October 13, 2017 1

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

October 12, 2017 4

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

October 11, 2017 3

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

October 10, 2017 2

SQL Puzzle: SQL Advance Query – Solve Date Overlapping Problem

October 9, 2017 1

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

Older posts Newer posts

About Me!