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

How do you know if a relationship is 2nf?

926


what is an alias command? : Sql dba

1074


What is forward declaration in pl sql?

1056


What is union and union all keyword in sql and what are their differences?

1086


What is on delete set null?

1071


can sql servers linked to other servers like oracle? : Sql dba

989


what are dynamic queries in t-sql? : Transact sql

1004


what is denormalization. : Sql dba

1088


Explain the working of foreign key?

1047


Why is theta join required?

1125


How to set up sql*plus output format in oracle?

1015


Explain how to use transactions efficiently : transact sql

955


What is a memo field?

946


What are the three forms of normalization?

1033


tell us something about heap tables. : Sql dba

1077