Answer / shekhar

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM tblSalary
ORDER BY salary DESC) S
ORDER BY salary

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--

Answer / jey ganesh

select min(sal) from employee where sal in(
select top 3 sal from employee order by sal desc)

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

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

Answer / vijay saxena

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM tblSalary
ORDER BY salary DESC)

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

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

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

What is the contrast between sql and pl/sql?

0 Answers  

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

How do I make a resultset scrollable?

0 Answers  

List few advantages of stored procedure.

0 Answers  

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

Which index created when Create Index on table(col), Why

2 Answers   CGI,

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

What is a rownum?

0 Answers  

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

How to delete database objects with "drop" statements in ms sql server?

0 Answers