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 / g.sivanagaraju

SELECT DISTINCT(A.SAL)
FROM EMP A
WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
FROM EMP B
WHERE A.SAL<=B.SAL);

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data definition language?

1136


What are sql built in functions?

981


What is java sql connection?

1120


What is a unique key and primary key and foreign key?

1022


What is the usage of when clause in trigger?

1091


Explain the update statement in sql

1044


What is the meaning of disabling a trigger?

1237


tell me about various levels of constraint. : Sql dba

1075


How many clustered indexes can be created on a table?

1122


Does user triggers have entry for trigger with compilation errors?

1091


How do you write a complex sql query?

1142


How do you use join?

995


How are sql commands classified?

1143


What is the use of double ampersand (&&) in sql queries? Give an example

1189


Can a foreign key be null?

1144