Write a query to find second highest salary of an employee.
Answer Posted / 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);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What java api is required for generating pdf reports?
How to capture Dos Promote data in text file? in that how to find particular String ( window )? in VB scrpting
How did you use automating testing tools in your job?
What is a ‘test plan’? What is a ‘test case’?
Hello, Is there any source from which i can get any live tutorial or trial of Automation tools?? Also i have a query that is there any certification course or exam available for Automation tools QTP and QC?
Tell me what databases can test director reside on?
What all things can you automate?
Hi, here r some questions, which were asked in Ekaplus, plz process these questions. 1. How we connect with the version?
Tell me how would you test your own element locator?
How to get the Background color of a Tab or Button in TestComplete Tool using VBScript? I have a validation that to verify whether a particular tab or button is highlighted or not. When the tab or button is highlighted the background color will be in Yellow color.If i get the background color then its easy for us to validate whether its highlighted or not. Can anybody help me on this?. Thanks in Advance.
What is the deference between automation tools and management tools?
What are the references for TSL functions.? Could anybody suggest me recommended book for Test Script Language.
How do you choose which automation tool is best for your specific scenario?
how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns
Tell us what methods of robot class do you know?