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 / sudheer

select salary from employee e
where 100=(select count distinct salary) from employee where
e.salary<=salary

Is This Answer Correct ?    3 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is execution plan in sql?

1039


Difference between global and parameter variables?

1963


Which are the different character-manipulation functions in sql?

1059


Write a sql query to convert all character to uppercase after hypen.

1434


What are the two types of exceptions.

1158


How is indexing done in search engines?

980


What is embedded sql what are its advantages?

1032


How do you copy a table in sql?

1066


Why do we need databases?

1036


Explain raise_application_error.

1088


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1220


What is bulk collect in pl sql?

1086


How global cursor can be declare with dynamic trigger ?

2206


Can we use pl sql in mysql?

1009


What are some predefined exceptions in pl/sql?

1164