SQL Data Analyst Interview Question | Extract domain name from email | EP-10 |
🚀 Extract Username and Domain from Email Using SQL!
In this video, I walk you through an essential SQL concept:
👉 "How to extract the username and domain from an email address using SQL."
🔍 You'll learn:
✅ How to use SUBSTRING() and CHARINDEX() for email parsing
✅ How to extract the username before @
✅ How to extract the domain after @
✅ Step-by-step explanation with practical examples
Whether you're preparing for an interview or enhancing your SQL expertise, this video will give you the confidence to handle string manipulation queries with ease.
💡 Don't forget to like, comment, and subscribe for more SQL tips and tutorials! 🚀
📌Script:-
CREATE TABLE std (
id INT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
email VARCHAR(100) NOT NULL
);
INSERT INTO std (id, name, email) VALUES
(1, 'Rajesh Kumar', '[email protected]'),
(2, 'Anita Sharma', '[email protected]'),
(3, 'Vikram Singh', '[email protected]'),
(4, 'Priya Gupta', '[email protected]'),
(5, 'Amitabh Das', '[email protected]'),
(6, 'Sneha Reddy', '[email protected]'),
(7, 'Arjun Mehta', '[email protected]'),
(8, 'Kavita Jain', '[email protected]'),
(9, 'Manoj Verma', '[email protected]'),
(10, 'Pooja Nair', '[email protected]');
#sql #plsql #trend #sqlqueryinterviewquestionsandanswers #sqlinterview #excel #infosys #postgresql #sqlserver #oraclesql #2025 #capgemini #dataanalyst #dataanlysis #interviewquery #deloitte #tcs #sqlite #sqltips #sqlforbeginners #sqlinterviewquestions #sqlqueryinterviewquestionsandanswers #kpmg #google #facebook #netflix #big4 #placement #amazon #youtubeshorts #youtube