Select top 1 empid,salary from (select distinct top 2 empid,salary from e

how to calcuate the second highest salary of he employee

Question Posted / vinayak jamdar

Answer Posted / vinayak jamdar

Select top 1 empid,salary from (select distinct top 2
empid,salary from emp order by salary desc)a order by salary

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can you load data into multiple tables at once? : aql loader

1075

Can I create table without primary key?

1004

Can a table contain multiple primary key’s?

1104

Can delete statement be rollbacked?

991

Does view store data in sql?

970

What makes a good primary key?

1051

Can we join more than 2 tables in sql?

1027

What is a table in a database?

1051

Is mariadb nosql?

1045

How does left join work in sql?

1009

Which command is used to delete a package?

1179

What does pragma mean?

1062

How to rename a table?

1030

What is the use of sql trace?

957

how to enter numeric values as hex numbers? : Sql dba

1070