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)

How to open an application through scripting in QTP? Give me Syntax and example please

2 Answers  

What are the frameworks available in rc?

0 Answers  

Describe some problem that you had with automating testing tool.

0 Answers   Satyam,

Tell us the difference between assert and verify commands?

0 Answers  

Tell me how could the web element attributes be inspected in order to use them in different locators?

0 Answers  

What is hybrid automation?

0 Answers  

Tell me what are the different types of navigation commands?

1 Answers  

i am living in pune.from 2 months i am searching s/w testing class.but i am confuse which is the good.please send me reply who complete their testing course..i want where teaching is very good & give real project.because many insti.assured placement & real time project,but after addmission it will not be true.so send me reply.i also confuse where i put my query.i hope so,will get reply soon

5 Answers  

What are the important operations in database testing?

0 Answers  

Tell me what criteria do you consider for automating a test?

0 Answers  

Tell me how a text written in a text field could be cleared?

0 Answers  

Hi all I need QA automation testing interview questions. pls help me in this topic. The interview is related to verification & validation of web based products. ( i want questions based on this topic ) where can i find interview questions realated to this? This is urgent requriment for me. pls share your inputs. any kinda help appreciaed. warm regards Lina.

0 Answers   Rogers,