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

Find out the 3rd highest salary?

Answer Posted / umesh naik

select max(amount) from (
select distinct amount from temp123
where rownum <= 3
)

Is This Answer Correct ?    1 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I use google cloud in sql?

1049


Why we use joins in sql?

935


Can you have more than one key in a database?

900


How do I create a sql database?

961


What is a stored procedure in sql with example?

1068


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2037


what is the difference between union and union all? : Sql dba

987


How do I edit a stored procedure?

960


What is the use of prepared statement?

965


How many commands are in sql?

1018


Can you skip header records while loading? : aql loader

991


How can you save or place your msg in a table?

968


What is embedded sql in db2?

972


Why join is faster than subquery?

1060


How do I view output in sql developer?

1035