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...

how to get top two salaries from employee tables

Answer Posted / maruti

select max(sal)
from emp
where sal < (select max(sal) from emp);

with this query u ll get second largest sal of that table
if u want to know max (sal) then it ll be...
select Max(sal)
from emp;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write test cases on wall

2216


How do you go about testing a project?

2014


hai friends can u expalin about real time process of testing at the company, like flow diagram

2107


hi, this is geetha, i have one doubt regarding the vulnerability testing. For sql injection testing is there any need for the tools to be installed. If it is what is tool and what is the method to test in sql injection testing. Plz Guide me

2089


qtp9.2 and qtp10.0 difference

3510


Explain the advantages of automation over manual testing?

1204


how will the test plan is pepared in ur organisation>?

2107


Why you are selected software testing as career ?

1425


Can you explain requirement traceability and its importance?

1210


What is defect cascading in software testing?

1420


What do you plan to become after say 2-5yrs (Ex: QA Manager, Why?)

2240


What are testing techniques? What is difference between general and specific?

2326


What are some best practices that you should follow when writing test cases?

1274


1...DIFF BETWEEN QTP AND WIN RUNNER? 2... CHECKPOINTS AND EXPLAIN EACH OF THEM? 3...WHY IS STEP GENERATOR? 4... WHAT IS THE DIFF BETWEEN FUNCTIONS AND SUB ROUTINE?

1982


How a test engineer will convince a test lead when he didn't approve the bug as a report ???

1690