SELECT * FROM EMPLOYEE E
WHERE 2 = (SELECT COUNT(DISTINCT E1.SALARY)
FROM EMPLOYEE E1
WHERE E1.SALARY>E.SALARY)
Here, 2= 3-1 i.e. N-1 ; can be applied for any number.
Blazor - ASP.NET Core
C#,MVC,ASP.Net Core,JQuery,SQL,Kendo UI,HTML,CSS,Bootstrap,Web API,Angular
0 Comments