What is CTE in SQL ? | Must know Data Analyst Interview Question
Learn what CTE is in SQL in the easiest way. In this video, we will understand why CTE is used, how it improves query readability, and how it helps break complex SQL logic into simple steps.
This is a must-know topic for Data Analyst interviews.
Execute Below Query to get dataset for Practice:
CREATE TABLE sales (
order_id INT,
customer_name VARCHAR(50),
city VARCHAR(50),
order_date DATE,
amount INT
);
INSERT INTO sales VALUES
(1, 'Rahul', 'Mumbai', '2024-01-05', 5000),
(2, 'Amit', 'Delhi', '2024-01-10', 7000),
(3, 'Rahul', 'Mumbai', '2024-02-12', 3000),
(4, 'Priya', 'Pune', '2024-02-15', 9000),
(5, 'Amit', 'Delhi', '2024-03-01', 4000),
(6, 'Priya', 'Pune', '2024-03-20', 6000); #dataanalytics #powerbi #businessintelligence
#SQL #CTE #DataAnalyst #SQLInterview #DataAnalytics #interviewpreparation