Sachin Kumar Profile picture
Mar 8 β€’ 4 tweets β€’ 3 min read
πŸ‘¨β€πŸ’» 10 different ways to remove duplicate records in SQL

🧡
1 - Delete using Unique Identifier.
2 - Using SELF join.
3 - Using Window function.
4 - Using MIN function. This delete even multiple duplicate records.
5 - Using backup table.
6 - Using backup table without dropping the original table.
7 - Delete using CTID.
8 - By creating a temporary unique id column.
9 - By creating backup table
10 By creating backup table without dropping the original table

πŸ“Follow @Sachintukumar for more

#SQL #sqlprogramming #sqlqueries #sqldatabase #dataanalytics #dataanalysis #datascience #data #businessanalytics #dataanalyst

β€’ β€’ β€’

Missing some Tweet in this thread? You can try to force a refresh
γ€€

Keep Current with Sachin Kumar

Sachin Kumar Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @Sachintukumar

Mar 6
6 Must have line charts for business data analysis πŸ“ˆπŸ‘Œ πŸ’―

🧡
1. Indexed chart for comparing trend
2. #Sparkline for tiny insight
3. Spaghetti line #chart for bringing focus
4. Smoothed line chart for evening out edge
5. Forecast chart to predict future value based on trend & seasonality
6. Line chart combination when just a line won't do
β–Ά Line charts are similar to #scatterplots except that they connect the data points with lines. Choose a line chart when ordering and joining the #data points by their X-axis values highlights meaningful changes in the vertical Y-axis variable.
Read 4 tweets
Feb 19
πŸš€ You can become a data analyst in 90 days without spending a cent! Yes, you heard that right.

With the right approach and dedication, anyone can become a #dataanalyst . Here are the steps to follow( Make sure the order is maintained)

🧡
Learn Excel - Time : 12 days
πŸŽ™οΈ Tutorials -
lnkd.in/eWmC2vf8
πŸ—οΈ Projects -
lnkd.in/ew5y5KP7
Learn Basic Statistics - Time : 3 days
πŸŽ™οΈ Tutorials -
lnkd.in/emKawHBs
Read 10 tweets
Feb 17
πŸ“Š Hey Folks

✍ So Day - 6 on #powerbi πŸš€

πŸ§΅πŸ‘‡
⚠ Today I Made a Awesome #America Retail Analysis Dashboard

πŸŽ‡ The beauty of Power BI is that you can look at each element to make better #decisions. The #dashboard's visual representation allows users to quickly see the #data that's relevant for the choices they have to make
πŸ”₯Then, define clear objectives to ensure that the dashboard accurately reflects your desired outcomes. πŸ‘‡

#PowerBI #100DaysOfCode #100daysofcodechallenge #Data #100daysofcoding #developer #DataScience #dataScientist #DataAnalytics #excel #SQL #tableau #visualization #Dashboard
Read 4 tweets
Feb 12
Are you looking to gain real-world πŸ“Šexperience in data science and analytics?

πŸ”₯ Here is a list of 10 top-notch virtual #internships with companies such as BCG, British Airways, GE, KPMG, Tata, and more.

πŸ§΅πŸ‘‡
1. KPMG Data Analytics Internship
lnkd.in/eUBvyFmd
2. BCG Data Science & Analytics
lnkd.in/e2eC27AR
Read 12 tweets
Feb 11
🎯- Day 28 of #SQL Series πŸ€–

πŸ’Ή Today I Solved a Two Amazing Questions πŸ“™

πŸ§΅πŸ‘‡
πŸ”—Q1) Problem Statement : Write a #Query to find no. of Gold Medal per swimmer for swimmer who won only Gold Medals .

#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLbySk #dataanalytics #business #sqlprogramming Image
Read 7 tweets
Feb 9
🐍Python is easy!

You can learn enough #Python in 8-10 hours to pick the rest up with active practice.

Here are my top 5 #free places to catch the basics:

πŸ§΅πŸ‘‡
1/ Codeacademy (where I first learnt Python) -
lnkd.in/eZnqKD_x
2/ MITx 6.0001 (this series is a brilliant intro to CS) -
lnkd.in/eeBXsQqr
Read 7 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(