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 out the third highest salary?

Answer Posted / santanu

3rd highest salary:

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe an oracle table?

1049


How to establish administrator authentication to the server?

1043


Explain the use of online redo log files in oracle.

1038


What do you understand by a database object? Can you list a few of them?

1018


What are the types of trigger in oracle?

984


material view and view disadvantages?

1073


What are oracle functions?

1030


can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122


When system tablespace is created?

1042


State any two functions of oracle?

1046


What is object data modeling?

969


Design database draw er diagram for a certain scenario ?

4579


How to use "in out" parameter properly?

1048


What is an oracle and why it is used?

1150


How to start an oracle instance?

1019