The query as Follows:
select top 1 salary from (select distinct top 2 salary from table1 order by salary desc) a order by salary
Here
salary-Column Name
table1-Table Name
a-Concatenation..It may be any other character
Subscribe to:
Post Comments (Atom)
-
What are Structural Design Patterns? A structural design pattern establishes a relationship between entities. Thus making it easier for...
-
To Execute the Remote Machine Process Example To reset the iis of remote machine ProcessStartInfo psi = new ProcessStartInfo("iis...
-
How to add double quotes to a string that is inside a variable? We can use double quotes on the string.Example : Declaration: ______...
No comments:
Post a Comment