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

17 Answers
21181 Views
HCL, IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is snapshot parameter in ssrs?

155

Tell me what is sql profiler?

1038

Can we insert data if clustered index is disabled?

951

What is normalization 1nf 2nf 3nf?

1064

What is the current limitation of the size of SQL Azure DB?

127

How do I completely remove sql server instance?

1107

how to avoid cursors? : Sql server database administration

980

When you should use a low fill factor?

1000

What is a partition function in sql server?

1146

Explain about analysis services?

1057

Difference between Inner vs outer joins?

956

What is @@error in sql?

1073

What do you mean by normalisation?

1051

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1084

Explain primary key and foreign key constraints?

1040