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

select salary from (select salary from sample where
rownum<11 order by salary desc) where rownum<2

Is This Answer Correct ?    3 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I count rows in sql query?

1005


How many times can we commit in a loop?

1029


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1444


Can we use ddl statements in stored procedure?

1162


what is an index? : Sql dba

1005


What are different clauses used in sql?

1125


How to handle bulk data?

1320


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1044


What is difference between stored procedures and application procedures?

1025


How do I send sql query results to excel?

1079


how to concatenate two character strings? : Sql dba

1112


What is query execution plan in sql?

1195


Define implicit and explicit cursors.

1150


What is the use of triggers?

1044


What does an inner join do?

1196