Wednesday, November 17, 2010

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

CREATE TABLE [dbo].[tblSalary]
(
[ID] [int] NOT NULL,
[Salary] [INT]
)
ON [PRIMARY]

INSERT INTO [tblSalary] ([ID],Salary) VALUES (1,20000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (1,30000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (2,40000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (3,50000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,60000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,70000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,80000)

select max(salary) from tblSalary
where salary < (select max(salary) from tblSalary)

No comments:

Post a Comment