select distinct a.sal from emp a where n=(select count(distinct b.sal) fr

how to find 2nd highest salary in random database salary of employer.....

Question Posted / rajasekhar.s

Answer Posted / rajasekhar.s

select distinct a.sal from emp a where
n=(select count(distinct b.sal)
from emp b where a.sal<=b.sal)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How much does mysql cost?

847

What is mysql57?

856

Why myisam is faster than innodb?

885

How many mysql connections can handle?

849

What is meant by sharding?

866

How can you validate emails using a single query?

837

What is mysql and why it is used?

1016

How do I install mysql workbench?

846

How can you plan the logshipping before processing?

2270

Why phpmyadmin is used for mysql?

875

What are date and time intervals?

923

Is sql and mysql same?

871

How do I rename a procedure?

821

What is a mysql view?

795

What is pragma serially_reusable and why is it used?

806