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 findout the 100th maximum salary

Answer Posted / raghuvir

select min(sal) from empl where romwnum < = 100 order by
sal desc

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pl sql quora?

1073


Can we use pl sql in mysql?

963


What is the difference between inner join and left join?

939


What do you understand by exception handling in pl/sql?

966


How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

993


What is the difference between functions, procedures, and packages in pl/sql?

975


What is sqlca in db2?

895


what are the types of join and explain each? : Sql dba

991


What is sql and how does it work?

1092


what is the use of set statement in tsql? : Transact sql

945


Which is faster count (*) or count 1?

969


The in operator may be used if you know the exact value you want to return for at least one of the columns.

1029


What are properties of the transaction?

958


what is 'mysqld'? : Sql dba

909


What is the use of non clustered index?

930