Answer / rajkumar mandala

select sal from
(select sal,(row_number() over (order by sal)) N from emp ) y where N= {value}

Replace {value} value with required highest value.
ie, 2 for 2nd highest

Answer / aj

select * from emp A where 1=(select count(*) from emp B
where A.SALARY < B.SALARY)

Answer / girase hitendrasing a.

select * from Employees where Salary in (select top 1
salary from (select distinct top 2 salary from employees
order by salary desc) order by salary asc)

Answer / bhaskar reddy thamma

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Answer / n.tejaswi

Select Empname
from emp LIMIT 2
orderby empsal;

Answer / khurram

The Simplest, easy, Understandable solution is

select max(sal) from emp where
sal not in
(select distinct Top 1 sal from emp order by sal desc)


Go Check Out for yourself
[replace "top 1" by "top 2" to get 3rd highest sal]
[replace "top 1" by "top 3" to get 4th highest sal] so on..

Answer / jyo

select salary from employee where salary>1st

Answer / ujwlala

select max(salary) from employee where salary<>(select
max(salary) from emp)

Answer / satish

select e1.* from emp e1 where 1=(select count(distinct
e2.sal) from emp e2 where e2.sal>e1.sal)

Answer / ashutosh singh

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

What do you like (not like) in this job?

1 Answers  

Best Online Training For Tosca Test Suite?Good Online Training For Tosca Test Suite?

0 Answers  

what is meant by framework? and when we use framework in our project ?

11 Answers  

What kind of tests should not be automated?

0 Answers  

When will you automate a test?

0 Answers  

how many clients are using this application?

1 Answers   Mind Tree,

which tools is the best in Automation

7 Answers   Satyam,

WHAT IS THE ARCHITECTURE OF QTP? IS THE ARCHITECTURE AND FRAMEWORK BOTH ARE SAME?

0 Answers  

What are main benefits of test automation?

0 Answers  

Is software requirement specification for developer and tester is same?

1 Answers  

I want to test a mobile software by an automation tool which is a IP telephony based software designed for both ios and android phone, basically this apps is develop for make call though few low cost audio codecs from Aircraft to Ground and Ground to Aircraft so anyone can suggest me which testing tool we can use for it

0 Answers   Tech Mahindra,

Explain me how do you send enter/tab keys in webdriver?

0 Answers