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

Answer Posted / sweety spear

select *from emp e1 where &n =(select count(*) from emp
where sal >= e1.sal);

Is This Answer Correct ?    13 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If i am doing the automation of test suites in a project. Then what will be the system interfaces for that?? The tools I am using or something else... please help..!!

1676


Give some examples for functional & regression test tools?

500


What issues come up in test automation, and how do you manage them?

1986


Explain me what the webdriver supported mobile testing drivers do you know?

578


test cases test wheather window? test cases to test calculaor? test cases to test a reverse string program? test cases to test program{ int.parse(sting str) $return (int)}? test cases to test program{display string length}?

1755






Discuss the economics of automation and the role of metrics in testing.

2032


What is the purpose of deselectall() method?

505


Explain what sikuli is?

596


hi to all, if we open a browser(for ex. yahoomail.com) using navigate command. the cursor by default focussing on the 'yahoo id' html edit box. how to get the label(ie.,yahoo id) of that html edit box using descriptive program. here we should not use identify tool to get the property,thtml editbox method. by tracing the cursor position we have to get the label name. is it possible? please let me know.

1724


Currently I do not have any automation in place in my project, but now I want to implement automation, what would be my steps?

635


What is tree view in automation testing?

561


What is hybrid automation?

575


If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.

1469


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.

1439


What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.

1534