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