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 / sheik

select top 1 * from(select top 3 *from emp order by salary
desc)d order by salary asc

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the advantages a stored procedure? : Sql dba

949


What is data profiling in sql?

1036


What's the procedure?

891


What are the differences between in and exists clause?

1074


What are primary key and foreign key and how they work?

947


What does the file extension accdb stand for?

938


How many triggers can be applied on a table?

903


what is table? : Sql dba

1029


What is sql in java?

1049


Inline the values in PL/SQL, what does it mean.?

1181


What are the events on which a database trigger can be based?

1149


What does data normalization mean?

923


What is sql clause?

1014


What is the command used to fetch the first 5 characters of a string?

1181


How do you rank data in sql?

961