Write a query to find second highest salary of an employee.

Answer Posted / hardit

select TOP 1[salary]
from(
select distinct TOP 2[salary]
from empTable
order by salary desc
) a
order by salary

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)

4945


I am new to jmeter and i am working on .net application.I am recording the requests and pop up images data are not recording.can some one suggest an idea regarding this

1587


Do you know how to check if a button is enabled on the page?

541


what r the diffence between QTP 8.2 & QTP9.0?

1634


Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?

492






What are the risks associated in automation testing?

648


HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?

1466


if i want to use different values in datatable with each iteration of for loop what would i do ??/

1654


Can you explain me what is object repository?

559


IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?

1879


Where you have applied oops in automation framework?

659


whether flash selenium supports to test Gaming application? like follows: identifying the images, dynamic animations, Dynamic value changes field and win conditions etcc..,

1496


Name some of the commonly used automation testing tools that are used for non-functional automation.

568


Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.

1622


Tell me what is tsl? What 4gl is it similar too?

582