SELECT MAX(E1.salary) FROM ggg E1 , ggg E2
WHERE E1.salary< E2.salary
2.select top 1 salary from ggg where salary<(select max(salary) from ggg)
order by salary desc
3.name salary
rahul 15000
ronak 20000
saumil 25000
create table ggg (name varchar(20),salary int)
insert into ggg values ('saumil',25000)
select * from ggg
Select MAX(Salary) from ggg
Select MAX(Salary) from ggg where Salary <> (Select MAX(Salary) from ggg)
select top 1 salary from ggg where salary<(select max(salary) from ggg)
order by salary desc
SELECT MAX(E1.salary) FROM ggg E1 , ggg E2
WHERE E1.salary< E2.salary
