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

select sal from emp e
where 100=(select count( distinct sal) from emp where
e.sal<=sal)

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are local and global variables and their differences?

1135


Define sql delete statement.

1063


Is sql procedural language?

1011


What will you get by the cursor attribute sql%rowcount?

1075


What program will open a mdb file?

1015


Can we connect to postgresql using sql developer?

1046


How do I debug a stored procedure?

1161


what is cross join? : Sql dba

1046


What are the types of keys?

1061


how can you see all indexes defined for a table? : Sql dba

1048


What is nvarchar max in sql?

1072


What is a dynamic query?

1069


What is trigger explain with example?

1088


Is pl sql different from sql?

1040


How do you pronounce sql?

1058