The Ultimate SQL Puzzles and SQL Server Advance SQL Queries…
- SQL Puzzle: SQL Advance Query – Find the Order basis on thier Status and Step
- SQL Puzzle: SQL Advance Query – Generate the group of Sequences
- SQL Puzzle: SQL Advance Query – Generate the range of data basis on common combination
- SQL Puzzle: SQL Advance Query – To generate the account balance column for Bank Accounts
- SQL Puzzle: SQL Advance Query – Place NULL for repeating values
- SQL Puzzle: SQL Advance Query – Report on Manager & Employee Nth level hierarchy
- SQL Puzzle: SQL Advance Query – Find the Week start day and Week end day for given Month
- SQL Puzzle: SQL Advance Query – Replace NULL with Previous Non Null value
- SQL Puzzle: SQL Advance Query – Generate the data in the RANGE format
- SQL Puzzle: SQL Advance Query – Do basic validation of Email Address
- SQL Puzzle: SQL Advance Query – Do the Multiplication for each Group
- SQL Puzzle: SQL Advance Query – Get the Last Sunday of Previous Week
- SQL Puzzle: SQL Advance Query – Check a String Is Number or Not
- SQL Puzzle: SQL Advance Query – Get last five rows without ORDER BY
- SQL Puzzle: Get the last three Records of a table
- SQL Puzzle: Find Correlation Coefficients for the Run of Cricket Players
- SQL Puzzle: Delete Duplicate Data without Primary key, ROW_NUMBER()
- SQL Puzzle: Generate Calendar Data for 19th Century
- SQL Puzzle: Use Recursive CTE, and list out the Years from Dates
- SQL Puzzle: Calculate the Power of Three
- SQL Puzzle: Find the Median Value from the Given Number
- SQL Puzzle: Use Group By, Find MIN MAX unit sold of a Month
- SQL Puzzle: Get the list of Monday of a Month
- SQL Puzzle: Find the upcoming Birthday for a Next Month
- SQL Puzzle: SQL Advance Query – How to get the Name of Month
- SQL Puzzle: SQL Advance Query – Get the DISTINCT String data after CONCAT
- SQL Puzzle: SQL Advance Query – Concat the String records without using STUFF function
- SQL Puzzle: SQL Advance Query – UPDATE Table from SELECT JOIN Statement
- SQL Puzzle: SQL Advance Query – Generate a Random number in the range of Fifty
- SQL Puzzle: SQL Advance Query – Count total number of Working Days between Two Dates
- SQL Puzzle: SQL Advance Query – Find last SET of String after Specific character
- SQL Puzzle: SQL Advance Query – Using Recursive CTE, Generates the Columns
- SQL Puzzle: SQL Advance Query – Divide a Column data into Multiple Columns
- SQL Puzzle: SQL Advance Query – Calculate SUM between Two Tables
- SQL Puzzle: SQL Advance Query – Create a function to get the string in InitCap Format
- SQL Puzzle: SQL Advance Query – Count the total number of missing Numbers
- SQL Puzzle: SQL Advance Query – Find the most repeated value of a Table
- SQL Puzzle: SQL Advance Query – Delete duplicate without using RANK, PARTITION, ROW NUMBER
- SQL Puzzle: SQL Advance Query – Find the count of Lowercase, Uppercase, Special Characters
- SQL Puzzle: SQL Advance Query – Find the Sum of privious values without using a self-join
- SQL Puzzle: SQL Advance Query – Alternate ORDER BY result for Male – Female Data
- SQL Puzzle: SQL Advance Query – Remove all NULL value and arrange other NON NULL
- SQL Puzzle: SQL Advance Query – Do PIVOT – UNPIVOT and Sort the result
- SQL Puzzle: SQL Advance Query – Find Employee with salary greater than their Manager
- SQL Puzzle: SQL Advance Query – Generate Fibonacci Series
- SQL Puzzle: SQL Advance Query – Fill the gap of Missing Codes
- SQL Puzzle: SQL Advance Query – Count the Even and Odd number occurrence
- SQL Puzzle: SQL Advance Query – Find the list of Years between Start Year and End Year
- SQL Puzzle: SQL Advance Query – Reduce duplicate column data by merging ID with it
- SQL Puzzle: SQL Advance Query – Search the percentage (%) character in table
- SQL Puzzle: SQL Advance Query – Display Year and Month data With or Without PIVOT
- SQL Puzzle: SQL Advance Query – Print START before group and Print END after group
- SQL Puzzle: SQL Advance Query – Find date range for same Market Rank
- SQL Puzzle: SQL Advance Query – Count the total Working days from the given dates
- SQL Puzzle: SQL Advance Query – To Swap the values in the Table
- SQL Puzzle: SQL Advance Query – Generate the report on Missing Year – Month data
- SQL Puzzle: SQL Advance Query – Find the average shared salary by each department
- SQL Puzzle: SQL Advance Query – Find the date of all third Sunday for Year 2017
- SQL Puzzle: SQL Advance Query – Check number is an Integer or not an Integer
- SQL Puzzle: SQL Advance Query – Split the String and generate count of Each part
- SQL Puzzle: SQL Advance Query – Use STUFF() and form the aggregate of columns
- SQL Puzzle: SQL Advance Query – Group and Count of Consecutive flags
- SQL Puzzle: SQL Advance Query – Concat repeated String with their Count
- SQL Puzzle: SQL Advance Query – If holiday on joining day, change joining date
- SQL Puzzle: SQL Advance Query – Find count of value from multiple columns
- SQL Puzzle: SQL Advance Query – Skip the first set of Zeros
- SQL Puzzle: SQL Advance Query – Find second highest salary for each department
- SQL Puzzle: SQL Advance Query – Find number of days of the Month of any date
- SQL Puzzle: SQL Advance Query – Find number the first day of Quarter of Year
- SQL Puzzle: SQL Advance Query – Solve Date Overlapping Problem
- SQL Puzzle: SQL Advance Query – Partition Employee Table in Three parts
- SQL Puzzle: SQL Advance Query – Find the Column name which has all NULL
- SQL Puzzle: SQL Advance Query – Print comma separated Divisions
- SQL Puzzle: SQL Advance Query – Solve the challenge of DISTINCT
- SQL Puzzle: SQL Advance Query – Find the range of missing years
- SQL Puzzle: SQL Advance Query – Generate Row number without any default function
- SQL Puzzle: SQL Advance Query – Find the Square of first Ten Number
- SQL Puzzle: SQL Advance Query – Split the number and Calculate addition
- SQL Puzzle: SQL Advance Query – Perform INTERSECT ALL to select all the common records
- SQL Puzzle: Write a Function to count the total number of word
- SQL Puzzle: SQL Advance Query – Print UP or DOWN or UpDown
- SQL Puzzle: SQL Advance Query – Replace Previous Date if difference is only for One Day
- SQL Puzzle: SQL Advance Query – Use PARSENAME() and Sort the IP-Addresses
- SQL Puzzle: SQL Advance Query – Use STUFF() and Mask the Credit Card Number
- SQL Puzzle: SQL Advance Query – Find the shortest path between two Roads
- SQL Puzzle: SQL Advance Query – Generate report on Start – End time basis on Corresponded IDs
- SQL Puzzle: SQL Advance Query – Create comma separated aggregation for Common schedules
- SQL Puzzle: SQL Advance Query – Find the Start – End Range for the Gap
- SQL Puzzle: SQL Advance Query – Find most awarded cricket match type
- SQL Puzzle: SQL Advance Query – Find max value from multiple columns
- SQL Puzzle: SQL Advance Query – Find a Book name which is printed in 50% of Languages
- SQL Puzzle: SQL Advance Query – Find third highest Employee Salary
- SQL Puzzle: SQL Advance Query – If column forms a sequence then print ‘Yes’ otherwise ‘No’
- SQL Puzzle: SQL Advance Query – Sort Products based on Versions
- SQL Puzzle: SQL Advance Query – To find total number of Sundays in a given Year
- SQL Puzzle: SQL Advance Query – Find first 100 Prime numbers in SQL Server
- SQL Puzzle: SQL Advance Query – Draw a Triangle without using any Loop
- SQL Puzzle: SQL Advance Query – Find the distinct combination from cross Columns
- SQL Puzzle: Advance SQL Query – Convert single cell of table into multiple Rows
- SQL Server Interview: Advance SQL Query – Don’t use pivot and Do Row aggregation into Column
- SQL Server Interview: Advance SQL Query – Find Permutations and Combinations of a String Column
- SQL Server Interview: Advance SQL Query – Find a count of repeated character in a String
- SQL Server Interview: Advance SQL Query – Find String values which are adjacent to each other
