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 / john bershan

select sgp from (select sgp,dense_rank() over (order by
sgp desc) as rownumber from t_policy_general)
where rownumber = '100';

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I run a sql script?

1161


What are the parts of a sql statement?

1096


Why stored procedure is better than query?

953


How to take user input in pl sql?

1169


Explain what is sql?

1121


What is sql*loader?

1200


Does sqlite need a server?

1059


What has stored procedures in sql and how we can use it?

1087


How to write html code in pl sql?

1119


What is the life of an sql statement?

1031


What is query syntax?

980


Is null operator in sql?

1048


what is a unique key ? : Sql dba

1101


Can delete statement be rollbacked?

992


How can one get sql*loader to commit only at the end of the load file? : aql loader

1068