19. Distinct IN SQL | sql tutorial
Hereβs a YouTube description for the DISTINCT Keyword in SQL: SQL DISTINCT Explained: Eliminate Duplicate Data! In this video, learn how to use the DISTINCT keyword in SQL to remove duplicates and retrieve only unique values from your query results. π―π β What is DISTINCT in SQL? The DISTINCT keyword ensures that only unique rows are returned, eliminating any duplicate data from your query result. Examples of DISTINCT Usage Retrieve unique departments: Want more similar videos- hit like, comment, share and subscribe β€οΈDo Like, Share and Comment β€οΈ β€οΈ Like Aim 5000 likes! β€οΈ βββββββββββββ Please like & share the video. βββββββββββββ script CREATE TABLE EMPL ( ID INT, NAME VARCHAR (17), SALARY INT, LOCATION VARCHAR(17), DEPT VARCHAR(17) ) INSERT INTO EMPL VALUES (1,'MANISH', 900000,'INDIA','SDE') INSERT INTO EMPL VALUES (2,'RANI', 1000000,'INDIA','SDE2') INSERT INTO EMPL (ID ,NAME,SALARY,DEPT) VALUES (3,'RAJ', 700000,'SALES') INSERT INTO EMPL VALUES (2,'RANI', 1000000,'INDIA','SDE2') INSERT INTO EMPL (ID ,NAME,SALARY,DEPT) VALUES (3,'RAJ', 700000,'SALES') βββββββββββββ AWS DATA ENGINEER : https://www.youtube.com/playlist?list=PLOlK8ytA0MghpdMjb0m9zu1v9s_qbRP0q Azure data factory : https://youtube.com/playlist?list=PLOlK8ytA0MgguN5XidtQXbILxwCdJCUJE&si=iEICXHP80zGchUYh Azure data engineer playlist : https://youtube.com/playlist?list=PLOlK8ytA0MghBrzu0i6WlTBdoO1WdwV_e SQL PLAYLIST : https://www.youtube.com/playlist?list=PLOlK8ytA0MggGXIKmbfZ-_Xqcos3JKdV- PYSPARK PLAYLIST - https://www.youtube.com/playlist?list=PLOlK8ytA0MgjvOpd-088NRU_vTYw_aryH βββββββββββββ π£Want to connect with me? Check out these links:π£ Join telegram to discuss https://t.me/+Cb98j1_fnZs3OTA1 βββββββββββββ what we have covered in this video: βββββββββββββ Hope you liked this video and learned something new :) See you in next video, until then Bye-Bye! βββββββββββββ
Download
0 formatsNo download links available.