Select Empname from emp LIMIT 2 orderby empsal;

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

Question Posted / n.tejaswi

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

Answer Posted / n.tejaswi

Select Empname
from emp LIMIT 2
orderby empsal;

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the scripting standard while performing automation testing?

1067

Please explain what is the hybrid framework?

1013

What is in-house tool?

977

Explain about basics of rational robot - ibm test automation tool?

1041

how to test an webbased application?

1999

1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: "test scenarios" & "test approch": points)

2070

What you know about table-driven testing?

1014

Can you list some other automation testing tools that you are familiar with?

997

Elaborate the fields in bug report in automated testing

944

WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?

2255

How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.

2385

i have one answer from you that today the test cases are not stored in the database(SQL server 2005). But in automation testing where does the test case store? plz tell me... i have more confusion

1969

Define sdlc in testing.

981

What is the different between GUI map and GUI map files?

2076

I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....

2292