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

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

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output to swap the values in the table.

Input Data:

Expected Output:

Create a table with data:

Solution:

Please try the different solution for this puzzle and share it via comment...

Anvesh Patel
SQL Puzzle: SQL Advance Query - Generate the report on Missing Year - Month dataSQL Puzzle: SQL Advance Query - Count the total Working days from the given dates
Comments: 4
  1. Jerry
    May 4, 2019 at 11:21 am

    SELECT CASE
    WHEN Col=’M’
    THEN ‘N’
    ELSE ‘M’
    END
    FROM SwapColumnData

    ReplyCancel
  2. Esha
    November 2, 2019 at 4:31 pm

    Very nice puzzles

    ReplyCancel
  3. Sarfaraz Mohammed
    December 23, 2019 at 11:57 am

    DECLARE @SwapColumnData TABLE(Col CHAR(1))

    INSERT INTO @SwapColumnData(Col)
    VALUES(‘M’), (‘N’), (‘N’), (‘M’), (‘N’), (‘N’);

    WITH CTE_Data1
    AS (SELECT DISTINCT
    scd.Col,
    DENSE_RANK() OVER(
    ORDER BY scd.Col) AS Rnk
    FROM @SwapColumnData scd)
    SELECT S.Col,
    scd1.Col
    FROM @SwapColumnData AS S
    INNER JOIN CTE_Data1 scd ON S.Col = scd.Col
    INNER JOIN CTE_Data1 scd1 ON scd.Rnk scd1.Rnk

    ReplyCancel
  4. karthick
    February 26, 2020 at 6:05 pm

    SELECT
    CASE
    WHEN col = ‘M’ THEN ‘N’
    WHEN col = ‘N’ THEN ‘M’
    END as anyname
    FROM swapcolumndata

    ReplyCancel

Leave a Reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

October 26, 2017 4 Comments SQL Puzzle, , , , , , , , , , ,