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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

find out the third highest salary?

Question Posted / joel

Answer Posted / joel

select sal from emp
where sal<(select max(sal) from emp
where sal in (select sal from emp
where sal < ( select max(sal) from emp)))

Is This Answer Correct ?    6 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are synonyms used for?

1034

How to recover a dropped table in oracle?

1042

What is Data Dictionary Cache in Oracle?

1163

How to resolve the ORA-39133 error in Oracle?

1110

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1014

How do I call oracle stored procedures that take no parameters?

1108

Explain temporal data types in oracle

1093

What is an oracle user role?

984

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353

How to drop an index?

955

What is catalog in Oracle?

1362

What is archive log in Oracle?

1131

Define oracle database

1041

What are the different oracle database objects?

1090

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2112