SQL Query to Eliminate Duplicate Pairs of Records
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
);
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
بـار بازدید شده