Second Highest Salary Department Wise. Group by
select * from
(
select EmpId, EmpName, Salary, Department,
ROW_NUMBER() Over (Partition by Department Order by Salary Desc) AS SalaryRank
from Emp
) dd
where SalaryRank = 2
Subscribe to:
Post Comments (Atom)
-
https://jwt.io/ J SON Web Tokens are an open, industry standard RFC 7519 method for representing claims securely between two parties.
-
public void ProcessOrder(int orderId, bool applyDiscount) { if(applyDiscount) { //Apply Discount to the order }...
No comments:
Post a Comment