select top 1 Coumn_Name from (select top 2 Coumn_Name from Table

Write query to fetch second maximum salary from employee table.

Question Posted / vijayalakshmi

Answer Posted / vijayalakshmi

select top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

3696

Is insert autocommit in oracle?

595

How to increment dates by 1 in oracle?

553

How to specify default values in insert statement using oracle?

549

What is oracle in java?

515

Difference between cartesian join and cross join?

534

what is IDE,DMV in sql server?

2233

What is the purpose of save points in oracle database?

535

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1559

How to convert characters to dates in oracle?

555

What is an oracle user role?

558

What do you mean by a tablespace?

558

Can we write insert statement in function in oracle?

524

What is the usage of synonyms?

572

What is set operator oracle?

519