Asp.net Trick is blog for asp.net article and information.
SELECT EmpID, EmpName, SalaryFROM EmployeeDetails AS e1WHERE (1 = (SELECT COUNT(DISTINCT Salary) AS Expr1 FROM EmployeeDetails AS e2 WHERE (Salary > e1.Salary)))
SELECT EmpID, EmpName, Salary
ReplyDeleteFROM EmployeeDetails AS e1
WHERE (1 =
(SELECT COUNT(DISTINCT Salary) AS Expr1
FROM EmployeeDetails AS e2
WHERE (Salary > e1.Salary)))