Loading video...

Video Failed to Load

Go Home

WHERE 1 = 1 in SQL Explained! (And why you should use it) #dataanalyst #dataanalysis #sqltips #sql #sqlsyntax

imelijahbutler's profile picture

Elijah Butler

198,500 subscribers

227,800 views • 3 months ago •via TikTok

EducationScience & Technology#dataanalyst#dataanalysis#sqltips#sql#sqlsyntax
LIVE

Anya Rossi• Live Now

Private livecam show

0 Comments

No comments available

Comments from the original post will appear here

Related Videos

Learn SQL can be easy! #learnsql #data #dataanalysis #datascience #dataanalyst #sqltips #learnontiktok
3:00

Learn SQL can be easy! #learnsql #data #dataanalysis #datascience #dataanalyst #sqltips #learnontiktok

mavenanalytics

916,600 views • 4 years ago

Everything you need to know about SQL for complete beginners! #clearsquare #dataanalyst #dataanalysis #sql #coding
2:12

Everything you need to know about SQL for complete beginners! #clearsquare #dataanalyst #dataanalysis #sql #coding

ClearSquare

960,500 views • 1 year ago

How to use the RANK() window function in SQL 🌟 #dataanalyst #dataanalytics #dataanalysis #data #analyst #sql #rank #windowfunction #windowfunctions #sqlcode #coding #programming #techjobs #breakintotech #techtok #wfh #workfromhome #wfhjobs #remotejobs #remotework
1:57

How to use the RANK() window function in SQL 🌟 #dataanalyst #dataanalytics #dataanalysis #data #analyst #sql #rank #windowfunction #windowfunctions #sqlcode #coding #programming #techjobs #breakintotech #techtok #wfh #workfromhome #wfhjobs #remotejobs #remotework

Mary | Data Analyst

51,800 views • 1 year ago

How to do a simple JOIN in SQL #dataanalyst #dataanalysis #dataanalytics #data #analyst #sql #joins #sqljoin #sqljoins #sqlcode #coding #programming #sequel #breakintotech #techjob #techjobs #techtok #datatok
2:31

How to do a simple JOIN in SQL #dataanalyst #dataanalysis #dataanalytics #data #analyst #sql #joins #sqljoin #sqljoins #sqlcode #coding #programming #sequel #breakintotech #techjob #techjobs #techtok #datatok

Mary | Data Analyst

80,600 views • 2 years ago

Seriously don’t apply #dataanalyst #dataanalysis #dataanalytics #data #analyst #techjob #techjobs #techlayoffs #sql #powerbi #tableau #excel #datascience #datascientist #wfh #workfromhome #wfhjobs #remotejob #remotejobs #remotework
1:51

Seriously don’t apply #dataanalyst #dataanalysis #dataanalytics #data #analyst #techjob #techjobs #techlayoffs #sql #powerbi #tableau #excel #datascience #datascientist #wfh #workfromhome #wfhjobs #remotejob #remotejobs #remotework

Mary | Data Analyst

738,400 views • 2 years ago

How I would become a data analyst in 2026? this is complete roadmap with step by step guide in 4 minutes. Watch till the end 📈 What role should I cover next? ##dataanalyst##datatok##dataanalysis##sql##python
4:31

How I would become a data analyst in 2026? this is complete roadmap with step by step guide in 4 minutes. Watch till the end 📈 What role should I cover next? ##dataanalyst##datatok##dataanalysis##sql##python

Sundas

331,000 views • 1 year ago

Formatting is not an advanced SQL skill, but all advanced users have good SQL formatting 😉 If you have a SQL test in your data analyst interview, here are two formatting tricks that show you’ve actually used SQL on the job 👇 1️⃣ WHERE 1=1 Add this to your where clause and you can comment out and swap different conditions without breaking your query. Analysts do this every day and it is a small but real time saver when you are working with SQL queries constantly. 2️⃣ Comma before the column name Put each column on its own line with the comma in front. It makes it easy to remove or comment out columns you do not need without breaking anything. The way you format your code is important! If you do these two things, it is clear you have experience debugging SQL code. Want more? I made a free Data Analyst Interview Cheat Sheet with the exact SQL and Excel skills they test you on in interviews. Link in bio 🤓 ⚠️ Note: This applies to data analyst, marketing analyst, and business analyst roles. If you are interviewing for an engineering role, YMMV #sql #dataanalyst #interviewtips
0:26

Formatting is not an advanced SQL skill, but all advanced users have good SQL formatting 😉 If you have a SQL test in your data analyst interview, here are two formatting tricks that show you’ve actually used SQL on the job 👇 1️⃣ WHERE 1=1 Add this to your where clause and you can comment out and swap different conditions without breaking your query. Analysts do this every day and it is a small but real time saver when you are working with SQL queries constantly. 2️⃣ Comma before the column name Put each column on its own line with the comma in front. It makes it easy to remove or comment out columns you do not need without breaking anything. The way you format your code is important! If you do these two things, it is clear you have experience debugging SQL code. Want more? I made a free Data Analyst Interview Cheat Sheet with the exact SQL and Excel skills they test you on in interviews. Link in bio 🤓 ⚠️ Note: This applies to data analyst, marketing analyst, and business analyst roles. If you are interviewing for an engineering role, YMMV #sql #dataanalyst #interviewtips

brooke | learn coding + ai

139,100 views • 5 months ago

IYour login form can be hacked with 1 line 💉👇 This is SQL Injection — the #1 backend attack that still owns companies in 2025. ' OR '1'='1 That's it. That's all it takes to dump your entire database if you do this: ❌ query = "SELECT * FROM users WHERE email = '" + input + "'" ✅ FIX IT LIKE THIS: Use prepared statements / parameterized queries. Always. I explained the full attack + how to prevent it in this reel. Save this before your next interview. Share with that friend who still concatenates SQL strings.
0:53

IYour login form can be hacked with 1 line 💉👇 This is SQL Injection — the #1 backend attack that still owns companies in 2025. ' OR '1'='1 That's it. That's all it takes to dump your entire database if you do this: ❌ query = "SELECT * FROM users WHERE email = '" + input + "'" ✅ FIX IT LIKE THIS: Use prepared statements / parameterized queries. Always. I explained the full attack + how to prevent it in this reel. Save this before your next interview. Share with that friend who still concatenates SQL strings.

codedevguy

19,300 views • 3 months ago

It's launch week . 5 days 5 launches Day 1: SQL Server Data Connector Now you can connect your SQL Server to Julius in just a few clicks and instantly explore your data. Track adoption, analyze performance, and access KPIs all without writing a single line of SQL
1:32

It's launch week . 5 days 5 launches Day 1: SQL Server Data Connector Now you can connect your SQL Server to Julius in just a few clicks and instantly explore your data. Track adoption, analyze performance, and access KPIs all without writing a single line of SQL

rahul

48,216 views • 1 year ago

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?
0:40

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?

Google for Developers

11,376 views • 8 months ago

"nooo you cant map government spending in a SQL database and allow everyone to use it, you dont have a degree" The beaver builds the dam regardless
0:27

"nooo you cant map government spending in a SQL database and allow everyone to use it, you dont have a degree" The beaver builds the dam regardless

Beaver 🦁

86,578 views • 10 months ago

FREE DATA ANALYTICS CERTIFICATION BOOTCAMP #dataanalyst #dataanalytics #dataanalysis #techjobs #breakintotech
0:43

FREE DATA ANALYTICS CERTIFICATION BOOTCAMP #dataanalyst #dataanalytics #dataanalysis #techjobs #breakintotech

Elijah Butler

41,600 views • 1 month ago

(includes partner resources) the links for the resources are listed here for easy access! the link is also in my bio! resources: learn SQL (beginner to advanced) in 4 hours: SQL toolkit for data engineering: SQL murder mystery: SQL scavenger hunt: ##learnsql##sql##learncoding##yay##softwareengineer
0:45

(includes partner resources) the links for the resources are listed here for easy access! the link is also in my bio! resources: learn SQL (beginner to advanced) in 4 hours: SQL toolkit for data engineering: SQL murder mystery: SQL scavenger hunt: ##learnsql##sql##learncoding##yay##softwareengineer

eggintech

288,600 views • 9 months ago

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results
5:48

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results

Alex Xu

23,200 views • 2 months ago

Cleaning your data in Power Query—the basics 📝 #dataanalyst #dataanalysis #dataanalytics #powerbi #clearsquare
2:13

Cleaning your data in Power Query—the basics 📝 #dataanalyst #dataanalysis #dataanalytics #powerbi #clearsquare

ClearSquare

41,200 views • 9 months ago

Установка серверов sql+1С (полное руководство) #server #sql #1С #sqlserver #сисадмин
6:06

Установка серверов sql+1С (полное руководство) #server #sql #1С #sqlserver #сисадмин

Yurik_switch

148,100 views • 1 month ago

How hackers use SQL Injection to compromise a website
13:03

How hackers use SQL Injection to compromise a website

𝐇𝐚𝐦𝐳𝐚 | Networking Guy

18,935 views • 1 month ago