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 find nth highest salary

Answer Posted / udathayadav

select * from tablename.aliasname where nth=select
count(sal) from tablename where aliasname.sal<=sal

Is This Answer Correct ?    38 Yes 26 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use the inserted and deleted pseudo tables?

961


what are different types of raid configurations? : Sql server database administration

1055


What is collation sensitivity? Explain different types.

1008


Does sql server 2016 have ssms?

960


How to get the definition of a stored procedure back?

977


What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1014


What happens when transaction log is full?

925


What is shrink log file?

897


Why is replication required on the sql server?

1060


What is a result set object returned by odbc_exec()?

1028


What is the report model project?

141


What are sql dirty pages?

1021


What is the maximum size of column in sql server?

891


What is the correct order of the logical query processing phases?

936


What is 2nf in normalization?

997