writing a query to get the second highest value in atable by using select statement

[konaravikumar]

writing a query to get the second highest value in atable by using select statement

[debasisdas]

As you have posted a question in the articles section it is being moved to Oracle Forum.

MODERATOR.

[debasisdas]

writing a query to get the second highest value in atable by using select statement

Kindly post the query that you have tried to solve this.

[arulkumara]

writing a query to get the second highest value in atable by using select statement

Hi
try this

select level,max(salar y) from emp1
where level=2
connect by prior salary>salary
group by level;

here salary->column

[arulkumara]

writing a query to get the second highest value in atable by using select statement

Hi
try this

select level,max(salar y) from emp1
where level=2
connect by prior salary>salary
group by level;

here salary->column name

[amitpatel66]

Hi
try this

select level,max(salar y) from emp1
where level=2
connect by prior salary>salary
group by level;

here salary->column name

Try below Query:

[code=oracle]
SELECT min(e.salary) FROM emp e WHERE 2 > (SELECT COUNT(*) FROM emp WHERE salary > e.salary)
[/code]