Third Highest Salary in SQL

-
SELECT salary
FROM (
    SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank
    FROM employees
) AS ranked_salaries
WHERE rank = 3;

Comments

Post a Comment

Popular posts from this blog

Deploy a .NET Core application on Hostinger

-
You can deploy a .NET Core 9 (ASP.NET Core) application on Hostinger — but only using their Linux VPS (not shared or Windows hosting). Here's how it works and what plan you'd need: ✅ Supported? Hostinger doesn’t support classic ASP.NET on Linux. Instead, you deploy ASP.NET Core apps on their Ubuntu 22.04 VPS via terminal and reverse-proxy (NGINX) ( support.hostinger.com ). 🛠 Recommended VPS Plans for .NET Core 9 Hostinger offers four KVM-based VPS tiers optimized for ASP.NET Core deployments ( hostinger.in ): Plan vCPU  RAM NVMe SSD Bandwidth Price (India, 24‑mo) KVM 1 1 4 GB 50 GB 4 TB ₹429/month (renews ₹699) KVM 2 2 8 GB 100 GB 8 TB ₹599/month (renews ₹949) KVM 4 4 16 GB 200 GB 16 TB ₹799/month (renews ₹1,999) KVM 8 8 32 GB 400 GB 32 TB ₹1,699/month (renews ₹3,999) (Prices from Hostinger India, 24‑month term) ( hostinger.in ) ⚙ Which Plan Should You Choose? Small/personal apps → KVM 1 (1 vCPU, 4 GB RAM) is ...
Read more

जगातील प्रसिद्ध बिझनेसमन्स

-
बिल गेट्स –  जगातील प्रसिद्ध बिझनेसमन्सपैकी एक आहेत बिल गेट्स. त्यांनी पर्सनल कम्प्युटरचा शोध लावला. ‘मायक्रोसॉफ्ट’ कंपनीचे निर्माण ही त्यांनी केले. आज आपल्या ऑफिस आण...
Read more

Singleton Design Pattern Realtime Example of banking

-
Image
Logger Utility in a Banking System using Singleton In a banking application, you might have a logger that logs important events like transactions, errors, and user activities. You want to ensure that only one instance of the logger exists throughout the application to maintain a consistent log format and avoid file access conflicts. 1) Why Singleton? A logging class doesn't need multiple instances. One instance is sufficient and more efficient. 2) Consistency: All log messages are centralized through one instance. 4) Resource Management: Avoids file access conflicts and redundant memory usage. using System; public sealed class Logger {     private static Logger instance;     // Private constructor to prevent instantiation from outside     private Logger()    {         Console.WriteLine(" Logger Initialized. ");     }     // Public method to get the single instance     public static Logger ...
Read more