Answer / belson gnana pradeep

Select Top 1 salary from (Select TOP 2 salary from tbl_salary order by salary desc)a order by salary

Answer / ankit nanda

select [Salary],ID from (select [Salary], ROW_NUMBER() over
(order by Employee.SALARY desc)RowNum from [Employee])e
where e.RowNum=2

Answer / sudip mondal

select top 1 from employee where ID in (select top2 ID from
employee order by Salary desc) order by Salary asc

Answer / radhakrishnan vaithilingam

SELECT TOP 1 id.salary
FROM (SELECT TOP 2 id,salary
FROM employee
ORDER BY salary DESC )a
ORDER BY a.salary ASC

Answer / bennison terry

Select Top 1 * from Tbl_Salary where ID not in (Select top 1 ID from tbl_salary order by salary desc) order by Id desc

Answer / ankit nanda

Do onething
just create a function which use the three input parameters
and
while select * from ComputeEmployee(,,,)insert one of the
designation or salary or department at a time or wtever u
want....here i used some case statement to solve the
problem..wheeeeww...one thing else uniqueidentifier i just
use for the column type,u can use a simple int also ::))


create function ComputeEmployee(@Designation nvarchar
(100),@Department nvarchar(100),@Salary bigint)
returns @DemoTable table (EmployeeID
uniqueidentifier,Designation Nvarchar(100),Name Nvarchar
(100),Department Nvarchar(100),Salary bigint)
as
begin
insert into @DemoTable
select
ed.EmployeeID,ed.Designation,ed.Name,sd.Department,sd.Salary
from EmployeeDetails ed inner join
SalaryDetails sd on sd.SalaryID=ed.EmployeeID
where ed.Designation like case when
@Designation IS not null then '%'+@Designation+'%' end
AND sd.Department like case when
@Department IS not null then '%'+@Department+'%' end
AND sd.Salary =case when @Salary Is not
null then @Salary else sd.Salary end
return
end

Answer / bhagya

select * from emp as e1 where 1= (select count(*)from emp
as e2 where e1.sal<e2.sal)

What are the advantages of using stored procedures?

0 Answers  

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

How connect excel to sql server?

0 Answers  

What is row_number()?

0 Answers  

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

Explain user defined functions?

0 Answers  

What is stored procedure in SQL..??

2 Answers  

what is diffrent between store procedure and trigger

2 Answers