Understand Difference between ON and USING in SQL as a Data Analyst

Understand this important difference between SQL keywords as a data analyst!

When you work as a data analyst, you will perform a lot of Joins between multiple tables.

Also, we have two different keywords to provide a common column between tables namely – “ON” and “USING”.

𝗟𝗲𝘁 𝗺𝗲 𝗲𝘅𝗽𝗹𝗮𝗶𝗻 𝘆𝗼𝘂 𝘁𝗵𝗲 𝗱𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝗰𝗲 𝗯𝗲𝘁𝘄𝗲𝗲𝗻 𝘁𝗵𝗲 𝘁𝘄𝗼:

  • USING needs the exact column names in both tables while ON doesn’t.
  • USING is much more readable than ON.
  • The ON keyword will display a common column two times when you select specific columns in the result.
  • On the other hand, the USING keyword will display a common column once.

Also, mention some data analysis concepts that you guys want me to cover.

Enjoy. Like, Comment, and Follow for more!

#DataAnalyst #BusinessProblems #DataAnalytics #BusinessAnalyst #BusinessAnalytics #DataAnalysis #BusinessAnalysis #ProductAnalyst #DataAnalysisTips #AnalyticsCareer #BusinessProblems #CommunicationSkills #EffectiveCommunication #DataScienceCommunity #AnalyticsTips #DataWorkflow #AnalyticsBestPractices #DataProcesses #DataTypes #AnalyticsDocumentation #US #UK #Europe #Singapore #Germany #SQL #Python #PowerBI #Excel #AmazonRedshift #ABTesting #Remotework #GlobalRemoteWork #SalesAnalyst #HealthcareAnalyst #MarketingAnalyst #FinancialAnalyst #SalesAnalysis #FinancialAnalysis #HealthcareAnalysis #MarketingAnalysis #RemoteDataAnalyst #RemoteWork #USRemote #UKRemote #EuropeRemote #SingaporeRemote #HiringRemote #UjjwalJha

CATEGORIES:

Blog

Tags:

No responses yet

Leave a Reply

Your email address will not be published. Required fields are marked *

Latest Comments

No comments to show.