Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is data - driven automation?

2665


HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?

1996


why should we choose VSTET(Visual Studio Team Edition for Testers) and not QTP?pleas give me the reasons for "WHY" we have web and client server app, supports power builder and on windows OS so this is the background of tech and envir things we have and now VSTET is good to use or not? if "NO" then tell me why

2265


On what factors can you map the success of automation testing?

1038


Generic function for selecting a Radio Button in a Dialog

2403


What are the important operations in database testing?

999


Do you know what is the purpose of deselectall() method?

1025


Tell me what is intellij?

1199


What generally is the structure of a framework?

1042


What is self-referencing constraint in mainframe development?

945


What u mean by infrgistics control (What is infrgistics Controls)?

2117


Explain how to perform load-testing?

1054


what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please

2190


Give some examples of priority – severity defect levels.

991


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

2279