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...

find the third highest salary?

Answer Posted / farrukh shaikh

select vu.sal from
(select DENSE_RANK() over(order by sal desc) as sr,
sal from emp) vu
where vu.sr=3

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I learn sql in a week?

1082


Why do we use joins?

1047


What is the process of debugging?

1078


Can I create table without primary key?

1004


what are the different type of sql's statements ? : Sql dba

926


What is restrict in sql?

1122


What is a constraint? Tell me about its various levels.

1164


When you have to use a default "rollback to" savepoint of plvlog?

1204


Why do we go for stored procedures?

1063


Is sql low level language?

1023


what is the difference between union and union all? : Sql dba

1024


Mention what does plv msg allows you to do?

1126


What is sql*loader and what is it used for? : aql loader

1179


Which table is left in join?

983


What is embedded sql with example?

1056