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 are diverse clauses that form a part of sql?

1109

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1125

What is similarity and difference between truncate and delete in sql?

1151

How to insert multiple rows with one insert statement in ms sql server?

1178

Please differentiate between a local and a global temporary table?

1058

explain databases and sql server databases architecture? : Sql server database administration

1012

What are information schema views?

1028

What is sql server management studio? : sql server management studio

1122

How to execute a stored procedure in ms sql server?

1250

How you can find out if an index is useful to the optimizer?

985

What happens when converting big values to integers?

1057

Give me any three differences between Truncate and Delete.

1155

What is the difference between varchar and varchar(max) datatypes?

1133

How can we rewrite sub-queries into simple select statements or with joins?

1027

What is database replication?

1208