select * from emp as a where sal < 2 from emp as a1 on ( a.idno=

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

Question Posted / kavitha

Answer Posted / kavitha

select * from emp as a

where sal < 2 from emp as a1
on
(
a.idno=a1.idno
)

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is reference section?

943

How to run queries with sql server management studio express?

1022

What is sql server programming?

980

How to download and install microsoft sql server management studio express?

976

What is the purpose of data source?

957

What is a sql join?

954

What is cte (common table expression)?

979

What is a with(nolock)?

928

What is the difference between web edition and business edition?

111

List some case manipulation functions in sql?

968

Is sql server implemented as a service or an application? : Sql server database administration

897

List the different types of collation sensitivities in sql server?

976

What is report rendering ?

149

How do you identify a foreign key?

972

Comment,Datatypes are unlimited

2020