SQL Puzzle: SQL Advance Query – Find the Column name which has all NULL

Check the below input data and expected output to find the name of the column which has all NULL records. Input Data: [crayon-673bde19251c0547828556/] Expected Output: [crayon-673bde19251ca860812396/] Create a sample table with data: [crayon-673bde19251cc523365016/] Solution: [crayon-673bde19251cd107880830/] Please try the different solution for this puzzle and share it via comment... Reference taken from here: Oct 8, 2017Anvesh […]

October 8, 2017 2 SQL Puzzle

October 7, 2017 2

SQL Puzzle: SQL Advance Query – Print comma separated Divisions

October 6, 2017 5

SQL Puzzle: SQL Advance Query – Solve the challenge of DISTINCT

October 5, 2017 1

SQL Puzzle: SQL Advance Query – Find the range of missing years

October 4, 2017 6

SQL Puzzle: SQL Advance Query – Generate Row number without any default function

October 3, 2017 1

SQL Puzzle: SQL Advance Query – Find the Square of first Ten Number

October 2, 2017 1

SQL Puzzle: SQL Advance Query – Split the number and Calculate addition

October 1, 2017 1

SQL Puzzle: SQL Advance Query – Perform INTERSECT ALL to select all the common records

September 15, 2017

SQL Server 2016: Introduced Data Compression Algorithm to reduce the size of Table

September 14, 2017

SQL Server: Use sp_estimate_data_compression_savings for checking estimate object size and saving space

Older posts Newer posts

About Me!