SELECT MAX(e.salary) FROM emp e,emp e1 WHERE e.salary<e1.salary;

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

Question Posted / chandramami

72 Answers
130594 Views
ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
E-Mail Answers

Answer Posted / chandramami

SELECT MAX(e.salary)
FROM emp e,emp e1
WHERE e.salary<e1.salary;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do we Test the C++ and Unix Application Using Automated Tool.

2570

hi, I want to study TIA portla V11. where can I get online courses?

1977

How you report bug in to bugzilla

2351

Give some examples for functional & regression test tools?

1013

Do you know what is robot api?

1047

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}?

2358

can any one tell me the examples of white box testing

2546

In Selenium how a test suit is run and report is generated.

2443

notice the distinction between data driven testing and retesting?

1035

Explain what sikuli is?

1119

What is a framework for automation testing?

1148

What is javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?

1065

Do you know what is a data-driven framework?

1085

Tell me what is regression testing?

1108

write a programme to insert into elements in array?n finding duplicate characters in given sting?

2412