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

Explain sql delete command?

1028

What are the database roles? : sql server security

1145

Why use update_statistics command in sql server?

1029

What are statistics?

985

What is an index in a database?

959

what is a sub-report?

140

What is Sqlpaging in SqlServer 2005 ?

1045

What is the cartesian product of the table?

943

write an SQL query to list the employees who joined in the month of January?

1664

Explain difference between cross join and full outer join?

987

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1030

What are the events recorded in a transaction log?

981

How is table type constraint applied to a table?

962

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

994

How can I get data from a database on another server?

972