select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.
Answers were Sorted based on User's Feedback
Answer / shekhar
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM tblSalary
ORDER BY salary DESC) S
ORDER BY salary
Is This Answer Correct ? | 23 Yes | 4 No |
Answer / sumesh.s.g
--Sumesh.S.G--
SELECT TOP 1 salary
FROM (select top 3 Salary
from dbo.TBL_Employee
order by Salary desc) as TemTable order by Salary asc
--Happy coding--
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jey ganesh
select min(sal) from employee where sal in(
select top 3 sal from employee order by sal desc)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kiran
select empid,salary
from (select distinct empid,salary,
Dense_Rank() over(order by salary desc) as Rank
from dbo.EmpSalary) b
where b.rank=3
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sandeep saxena
CREATE procedure Proc_Loaddata_Text (@File_path nvarchar
(255),@Table_Name varchar(100)) AS
DECLARE @SQLString NVARCHAR(4000)
/* Build Command*/
SET @SQLString =N'Bulk Insert ['+@Table_Name+'] from ' +
N'N''' + @File_path + N''' with (FIELDTERMINATOR=''|'',
ROWTERMINATOR = ''\n'')'
--print @SQLString
/* Execute */
EXEC (@SQLString)
GO
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vijay saxena
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM tblSalary
ORDER BY salary DESC)
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / sunil nair
SELECT EmpID,Salary from tblSalary a where 3=(select count
(distinct EmpID) from tblSalary b where b.empid>=a.empid)
For any database
Is This Answer Correct ? | 2 Yes | 5 No |
Answer / sunil nair
SELECT EmpID,Salary from tblSalary a where 3=(select count
(EmpID) from tblSalary b where b.empid=a.empid)
for any RDBMS
Is This Answer Correct ? | 2 Yes | 13 No |
What is the difference between Clustered and Non-Clustered Index?
what's the maximum size of a row? : Sql server database administration
What is the use of “join” in sql server?
What is the need for group functions in sql?
Explain the stored procedure?
what type of index will get created after executing the above statement? : Sql server database administration
How to run sql server 2005 books online on your local system?
What is the difference between stored procedure and user defined functions?
What is built-in function?
Explain the disadvantages of cursors?
How to test subquery results with the exists operator?
how you can get the list of largest tables in a database? : Sql server administration