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

What about the test case if the field only takes a certain number of characters or a minimum number?

1122


Difference between adhoc testing and error guessing?

1104


What is test out put?

2069


can anybody send the project you have tested with the clear descriptions,and recent bugs u found in that

2106


whar are the contents in db testing test case template

2016


Can you explain steps in function points?

1048


Can you explain the elementary process?

1123


What is decision table testing?

1062


What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?

2075


Hi , Please send me the interview questions which were asked in manual testing mainly the test cases asked to write in interview.

1962


Risk Analysis a) 2 step, b)3 step, c) 4 step, d) 6 step

2010


Can anyone please tell in detail about the Rally tool and how a tester is going to use it.

2512


List the considerations in developing testing methodology

6664


what is fusion testing and impact analysis???

2258


what are the Cs in testing

2039