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

API development using .NET Core - ProductManagmentCRUD

-
Image
 1) Create Database and Table as mentioned below queries create table products(ProdId int Primary key, ProductName varchar(20), Price int ) insert into products (ProdId, ProductName, Price ) values (1,'Laptop','45000'); insert into products (ProdId, ProductName, Price ) values (2,'Mouse','500'); insert into products (ProdId, ProductName, Price ) values (3,'Router','1800'); select * from products; 2) Create ASP.NET Core API Project Install NuGet Packages  3)  AppSettings.json {   "Logging": {     "LogLevel": {       "Default": "Information",       "Microsoft.AspNetCore": "Warning"     }   },   "ConnectionStrings": {     "DbConnection": "Server=Server_name; Database=ProductManagementCrud; User Id=sa; password=oj#$kdfn; TrustServerCertificate=True;"   },   "AllowedHosts": "*" } 4) Model -  Product.cs namespace ProductManagmentCRUD.Mo...
Read more

Second Highest Salary using C# Linq

-
using System; using System.Linq; public class Program {     public static void Main()     {         int[] numbers = { 5, 12, 3, 9, 21, 21, 7 };         var secondHighest = numbers                             .Distinct() // Remove duplicates                             .OrderByDescending(x => x) // Sort in descending order                             .Skip(1) // Skip the highest                             .FirstOrDefault(); // Take the second highest         Console.WriteLine($"Second highest number is: {secondHighest}");     } }
Read more