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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how to find nth highest salary

Question Posted / kavitha.r

Answer Posted / kavitha.r

Sorry. This one is correct


select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc) order by
salary asc

Is This Answer Correct ?    44 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a view in sql?

1024

What is resource db in sql server?

1058

How check triggers in sql server?

1056

Explain about temporary stored procedure?

1099

What are the aggregate and scalar functions?

1137

List all the types of user-defined functions?

1186

Explain multiserver query

1113

Explain tablesample?

1041

What is the Main Difference between ACCESS and SQL SERVER?

1190

Explain concepts of analysis services?

1016

How will you make an attribute not process? : sql server analysis services, ssas

1160

What is a dbms wizard?

1074

Do you know what are the differences between lost updates and uncommitted dependencies?

1144

What is built-in/administrator?

1078

What is not null constraint?

1180