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
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)
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
Do you know how to check if a button is enabled on the page?
what r the diffence between QTP 8.2 & QTP9.0?
Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?
What are the risks associated in automation testing?
HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?
if i want to use different values in datatable with each iteration of for loop what would i do ??/
Can you explain me what is object repository?
IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?
Where you have applied oops in automation framework?
whether flash selenium supports to test Gaming application? like follows: identifying the images, dynamic animations, Dynamic value changes field and win conditions etcc..,
Name some of the commonly used automation testing tools that are used for non-functional automation.
Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.
Tell me what is tsl? What 4gl is it similar too?