Write a query to find second highest salary of an employee.
Answer Posted / vidhya
select max(column name) from table_name where((select max
(column name) from table_name Order by salary Desc) set
difference (select max(column name))
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
how to know whether the user information or any other information which is entered in to the web is storing in secured place or non secured place?
WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?
Is automation testing in agile methodology useful or not?
What is Ticketing tool? Has it any other names? What is the purpose of this?
How can the user get a text of a web element?
Highlight attributes of good framework?
What are the advantages of automation testing?
What is an automated test script?
why we cannot apply check points in compile modules?
What all different approaches can be used for designing an automation solution?
I want a code for a following item in TSL Language. Look up a person in database, If not found, add person to the database.
How do select which automation testing tool is the best for you?
What are the important modules of an automation testing framework?
Tell me what databases can test director reside on?
What are the steps involved in the automation process ?