<div>
oops, try this<br />
<br />
<br />
select * from Salary_Table <br />
where Basic_Salary=<br />
(select min(Basic_Salary) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from (select top 2 &nbsp;Basic_Salary from Salary_Table order by Basic_Salary desc)a)
</div>


oops, try this


select * from Salary_Table
where Basic_Salary=
(select min(Basic_Salary)
      from (select top 2  Basic_Salary from Salary_Table order by Basic_Salary desc)a)

<div>
<div class="content wysiwyg-content">
Hello,<br />
1: I have a table of following fields. <br />
code &nbsp; &nbsp;name &nbsp; &nbsp; &nbsp;basic_salary<br />
I want to to right a query or view which shows the second of &nbsp;highest basic salary. etc.<br />
code &nbsp; &nbsp;name &nbsp; &nbsp; basic_salary<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12000<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; xyz &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12000<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; ehd &nbsp; &nbsp; &nbsp; &nbsp; 11000<br />
<br />
so i want 11000(Basic Salary) figure <br />
Note: i did not know about highest salary.<br />
becuase i know the method show salary &lt;&nbsp;12000.<br />
but i write a blind query which can execute every where.(not perfectly knowing the highiest salary.<br />
<br />
Thanks.<br />
Haider.<br />
<br />

</div>
</div>


Hello,
1: I have a table of following fields. 
code    name      basic_salary
I want to to right a query or view which shows the second of  highest basic salary. etc.
code    name     basic_salary
1         abc          12000
2         xyz          12000
3         ehd         11000

so i want 11000(Basic Salary) figure 
Note: i did not know about highest salary.
becuase i know the method show salary < 12000.
but i write a blind query which can execute every where.(not perfectly knowing the highiest salary.

Thanks.
Haider.



Find Specific Record

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.