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

Answer Posted / pradeep kumar

Select max(salary) from emp where salary NOT IN (Select max
(salary) from emp)

Is This Answer Correct ?    95 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What should you do after finding a bug?

641


wat would be the parameteries for ul testing for web applilcation

1707


Tell us what is the difference between single slash (/) and a double slash ( //) in xpath?

650


How do you choose which automation tool is best for your specific scenario?

567


What do you think holds testers back to do automation? Is there a way to overcome it?

503






How would you test your own element locator?

547


Write a short compiled module which selects random numbers. and what function is used to call your customized compiled module?

528


Tell me how would you test your own element locator?

548


What are the most popular tools for automation testing?

556


Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines

1442


How do you select which automation tool is best suited for you?

542


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

1589


What are the drawbacks of test automation?

593


Describe some problem that you had with automating testing tool.

1884


I am fresher and i have completed my software testing course and i don't have real time experience,can anybody help me regarding financial domain projects,main testcases in that domain.

1805