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 findout the 100th maximum salary

Answer Posted / lince

select sal from
(
select row_number() over (order by sal desc) as rno,sal
from Emp
)T
where T.rno=100

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a call statement? Explain with an example.

1004


Why truncate is used in sql?

1003


Can we call a function containing dml statements in a select query?

974


what is foreign key? : Sql dba

1034


Explain what is dbms?

1055


How to use sql statements in pl/sql?

1117


What is a sql schema used for?

1096


What is foreign key sql?

985


What is difference between my sql and sql?

1064


What is localdb mssqllocaldb?

1066


How can you know that statistics should be updated?

1077


What view means?

975


What are all the different normalizations?

1026


What is sql constant?

1027


What is sql performance tuning?

917