SQL Query to Eliminate Duplicate Pairs of Records

Janardhan Reddy Bandi
Janardhan Reddy Bandi
2 هزار بار بازدید - پارسال - You can get all snowflake
You can get all snowflake Videos, PPTs, Queries, Interview questions and Practice files in my Udemy course for very less price.. I will be updating this content and will be uploading all new videos in this course.

My Snowflake Udemy Course:
https://www.udemy.com/course/snowflak...

I can be reachable on [email protected].
--------------
CREATE OR REPLACE TABLE DIST(SOURCE VARCHAR, DESTINATION VARCHAR, DISTANCE INT);

INSERT INTO DIST VALUES ('HYD', 'MUM', 700),
     ('MUM', 'HYD', 700),
     ('HYD', 'BANG', 570),
     ('BANG', 'HYD', 570),
     ('CHN', 'BANG', 320),
     ('BANG', 'CHN', 320),
     ('PUNE', 'MUM', 150);
SELECT * FROM DIST;

----------------

SELECT DISTINCT
CASE WHEN SOURCE GT DESTINATION THEN SOURCE ELSE DESTINATION END AS SOURCE,
CASE WHEN SOURCE LT DESTINATION THEN SOURCE ELSE DESTINATION END AS DESTINATION,
DISTANCE
FROM DIST;

----------------

SELECT SPLIT_PART('MY NAME IS JANA', ' ', 1);

SELECT DISTINCT SPLIT_PART(ROUTE,' ',1) SOURCE, SPLIT_PART(ROUTE,' ',2) DEST, DISTANCE FROM
(
SELECT
CASE WHEN SOURCE GT DESTINATION THEN SOURCE||' '||DESTINATION
   ELSE DESTINATION||' '||SOURCE END AS ROUTE,
DISTANCE
FROM DIST
);
پارسال در تاریخ 1402/01/12 منتشر شده است.
2,061 بـار بازدید شده
... بیشتر