Hi, I'm Deepak and I share daily knowledge about: 💻 Azure Cloud Solution 🏆 Microsoft Azure technologies 📦 Technical Blogs ⚡ Productivity tips 💼 Career development 🎉 Azure certifications 🚀 Technical queries and challenges If you want to learn, make sure to follow me! ✅

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

9. Get Employee Details with Department Names SELECT https://t.co/4PxeAB9a9r, d.department_name FROM employees e JOIN departments d ON e.department_id = d.department_id

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

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

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

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

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

https://t.co/WIHhQr1F8n

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

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

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.

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: https://t.co/gsX1y6N8MZ Do share, it might help someone else too.

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

✅ 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

“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

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.

Start your journey to become a data pro—learn Python live, from basics to advanced, absolutely free Course url: https://t.co/ruSLAgsxkh @deepakgoyalcloud

📍 Days 51–60: Subqueries & CTEs 📍 Days 61–70: Window Functions 📍 Days 71–80: Data Manipulation 📍 Days 81–90: SQL for Analytics 📍 Days 91–100: Capstone + Optimization 📚 Tap ❤️ for more!

Answer: Ask this question to either guardian: 👉 "If I were to ask the other guardian which door leads to Heaven, what would they say?" Then go through the opposite door of what they say. In both cases, you’re being misdirected—so the correct path is the opposite.

✅ *100 Days SQL Roadmap – 2025* 🗃️🧠 🕒 Daily: 1–2 hours + practice on real datasets 📍 *Days 1–10: SQL Basics* 📍 *Days 11–20: Filtering & Sorting* 📍 *Days 21–30: Functions & Expressions* 📍 *Days 31–40: GROUP BY & Aggregates* 📍 *Days 41–50: Joins Mastery*