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

konaravikumar

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(salary) 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(salary) from emp1
where level=2
connect by prior salary>salary
group by level;

here salary->column name

amitpatel66

Hi
try this

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

here salary->column name

Try below Query:

Expand|Select|Wrap|Line Numbers

 
SELECT min(e.salary) FROM emp e WHERE 2 > (SELECT COUNT(*) FROM emp WHERE salary > e.salary)

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ