Deepak Goyal @deepakunique

Azure Cloud Advocate • My tweets will help you get into tech and be an amazing Data Engineer • 210K+ Audience on LinkedIn • Check my Online Courses👇 academy.azurelib.com/enquiry My Work & Website Joined November 2009

Tweets

1K
Followers

6K
Following

111
Likes

540

Deepak Goyal @deepakunique

a month ago

10. Find all employees whose names contain the letters "a" exactly twice SELECT * FROM employees WHERE LENGTH(name) - LENGTH(REPLACE(LOWER(name),'a','')) = 2 11. Running total of sales by date SELECT date, sales, SUM(sales) OVER (ORDER BY date) AS RunningTotal FROM sales_data

0 0 0 182 0

Deepak Goyal @deepakunique

a month ago

9. Get Employee Details with Department Names SELECT e.name, d.department_name FROM employees e JOIN departments d ON e.department_id = d.department_id

0 0 0 120 0

Deepak Goyal @deepakunique

a month ago

7. Get Total Salary by Department SELECT department, SUM(salary) AS total_salary FROM employees GROUP BY department 8. Find Nth Highest Salary (Nth = 3) SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2

0 0 0 187 0

Deepak Goyal @deepakunique

a month ago

5. Find Employees Who joined in 2024 SELECT * FROM employees WHERE YEAR(joining date) = 2024 6. Find Customers Without Orders SELECT c.customer_id, c.name FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id WHERE o.customer_id IS NULL

0 0 1 135 0

Deepak Goyal @deepakunique

a month ago

0 0 2 160 0

Deepak Goyal @deepakunique

a month ago

4. How can you delete duplicate records WITH CTE AS ( SELECT column_name, ROW_NUMBER() OVER (PARTITION BY column_name ORDER BY column_name) AS row_num FROM table_name ) DELETE FROM CTE WHERE row_num > 1

0 0 5 315 1

Deepak Goyal @deepakunique

a month ago

3. Find Duplicate Records SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*)>1

1 0 11 663 2

Deepak Goyal @deepakunique

a month ago

0 0 2 185 0

Download Image

Deepak Goyal @deepakunique

a month ago

SQL INTERVIEW QUESTIONS SERIES : 1. Find the 2nd Highest Salary SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees) 2. Count Of Employees in Each Department SELECT department, COUNT(*) AS employee_count FROM employees GROUP BY department

0 2 12 513 9

Deepak Goyal @deepakunique

a month ago

Think SQL is outdated? Think again. The future of database querying is fast, flexible & built for 2025. Powered by developers, for developers. #NoLimits #TechRevolution #FutureOfData #CQL2025 #DevelopersLife #ModernSQL #ScalableTech #RealTimeData #AIIntegration #CloudComputing

1 0 1 506 1

Download Video

Deepak Goyal @deepakunique

2 months ago

How do you find the 2nd highest salary from an employees table? SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees); 💡Explanation: This filters out the max salary, then finds the next highest. 🎯 Tip: Use DENSE_RANK() for general Nth salary.

1 0 2 402 1

Deepak Goyal @deepakunique

2 months ago

To start your Data engineering / Data Analyst / Data Science journey I am starting a free live BootCamp to teach Python Starting from 04th August 2025 Mon to Fri 08:00 AM to 10:00 AM Register here for free: lnkd.in/dRAVwVHn Do share, it might help someone else too.

0 0 0 137 2

Deepak Goyal @deepakunique

2 months ago

Most candidates fail at this salary question! Your current salary ≠ your true value. Here’s how to answer it smartly.#salaryexpectation #interviewtips #jobinterview #reelsforyou #corporatelife #salarytalks

1 0 0 165 1

Download Video

Deepak Goyal @deepakunique

2 months ago

✅ Top 7 SQL Mistakes You Should Avoid🚫🛠️ 1️⃣ Not Using Indexes Properly 2️⃣ Using SELECT Instead of Specific Columns 3️⃣ Ignoring NULL Values 4️⃣ Not Using JOINs Correctly 5️⃣ Poor Query Optimization 6️⃣ Not Using Aliases for Tables/Columns 7️⃣ Ignoring Data Types and Conversions

0 0 3 241 1

Deepak Goyal @deepakunique

2 months ago

“SQL interviews confusing you? Let’s simplify Normalization in just 30 seconds – TCS & Cognizant favorites!” 💬 Comment "SQL" to get the free cheat sheet! #sqlsimplified #interviewready #normalizationexplained #tcsjobs #cognizantlife #codingreels #techcareer #datajobs

0 0 5 271 3

Download Video

Deepak Goyal @deepakunique

2 months ago

My biggest fear isn't failure. It's staying the same. Most people wake up every year with: same job same dreams Why? Because risk feels scary. Because comfort feels good. But here's the truth: Comfort is the enemy of growth.

0 0 2 176 0

Deepak Goyal @deepakunique

2 months ago

Start your journey to become a data pro—learn Python live, from basics to advanced, absolutely free Course url: academy.azurelib.com/checkout/Cours… @deepakgoyalcloud