Select Top 1 Salary from (select top 1 salary from xxx order by salary desc) as salary order by salary asc
TOP 2
Select Top 1 Salary from (select top 2 salary from xxx order by salary desc) as salary order by salary asc
Note
WHERE XXX Is Table name
Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package.
.Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier.
Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people,
system and devices through software".I'm Choulla Naresh..!