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 the 3rd max salary

Answer Posted / karthik

select min(salary) from (select top 3 * from employee order by salary desc) temp

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what are the advantages of using stored procedures?

988


What is 2nf normalization?

996


Why olap is used?

951


What is database architecture? : SQL Server Architecture

1015


What is inner join in sql server joins?

1010


What is cursors?

1153


How to transfer a table from one schema to another?

979


What is reference section?

982


Write a sql query to delete duplicate records from a table called table1

1008


How do database indexes work?

991


What is data source view or dsv? : sql server analysis services, ssas

981


Explain what are the authentication modes in sql server?

988


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

936


What is purpose of normalization?

928


What is the dbcc command and why is it used?

1030