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

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

What is data source object?

0 Answers  

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

What is an example of a foreign key?

0 Answers  

which backup strategy you are following at ur company

0 Answers  




Why it is recommended to avoid referencing a floating point column in the where clause?

0 Answers  

Explain the disadvantages/limitation of the cursor?

0 Answers  

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

What is checkpoint process in the sql server?

0 Answers  

Give an example of SQL injection attack ?

0 Answers   HAL,

Differentiate between a having clause and a where clause.

0 Answers  

What are the five characteristics of good data?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories