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..!
Showing posts with label Top One Salary and top 2 salary. Show all posts
Showing posts with label Top One Salary and top 2 salary. Show all posts
Thursday, June 19, 2014
Top One Salary and top 2 salary
TOP 1
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
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
Subscribe to:
Posts (Atom)