1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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.

Question Posted / shekhar

Answers were Sorted based on User's Feedback



select the 3rd maximum salary from sql server database if 4 (just an example In practically I may n..

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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may n..

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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may n..

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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may n..

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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may n..

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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may n..

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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may n..

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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may n..

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

Post New Answer

More SQL Server Interview Questions

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

Explain what is lock escalation?

0 Answers  

How to create a simple user defined function in ms sql server?

0 Answers  

How to check parameter value in stored procedure sql server?

0 Answers  

Do you know hot add cpu in sql server 2008?

0 Answers  




how to avoid cursors? : Sql server database administration

0 Answers  

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

syntax for deleting the database in T SQL

5 Answers  

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

What is an indice?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories