SQL Interview Problem: Splitting Full Names into First, Middle, and Last Names
In this video, we tackle a classic SQL interview question: how to split a full name into first name, middle name, and last name. Watch as we break down the solution step-by-step, using a real SQL problem to demonstrate practical techniques for handling name parsing in SQL. Perfect for preparing for SQL interviews or brushing up on string manipulation skills!
create table customers (customer_name varchar(30))
insert into customers values ('Vijay Kumar')
,('Vishal Pratap Singh')
,('Michael');
select * from customers;
Top SQL Interview Questions: RANK, DENSE_RANK, ROW_NUMBER Explained
• Top SQL Interview Questions: RANK, DENSE_R...
Top 3 Products by Sales & Employees by Salary | SQL Ranking Functions Explained
• Top 3 Products by Sales & Employees by Sal...
SQL Interview Challenge: Find Hidden Likes in Your Friends' Favorites!
• SQL Interview Challenge: Find Hidden Likes...
SQL Magic: Aggregating Marks & Delivery Dates with Advanced Queries!
• SQL Magic: Aggregating Marks & Delivery Da...
Top 20% vs Bottom 20% of Students in SQL: NTILE vs TOP PERCENT
• Top 20% vs Bottom 20% of Students in SQL: ...
SQL Tricks: Find the 3rd Lowest Salary in Each Department with Two Powerful Methods!
• SQL Tricks: Find the 3rd Lowest Salary in ...
SQL Tutorial: Find Employees Who Joined Before Their Managers
• SQL Tutorial: Find Employees Who Joined Be...
SQL Tutorial: Retrieve Specific Rows with OFFSET & ROW_NUMBER - Top 2 Methods Compared!
• SQL Tutorial: Retrieve Specific Rows with ...