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

Answer Posted / asadullahrao

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

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are synonyms used for?

1034

Explain index?

1258

How to see the table columns used in an index?

1023

What is a snapshot log?

1003

What is procedure overloading in oracle?

1057

How to create a new table by selecting rows from another table?

1092

What is the difference between substr and instr?

1037

How to convert numbers to characters in oracle?

1030

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022

material view and view disadvantages?

1070

List the types of joins used in writing subqueries?

995

How to manage transaction isolation level?

1002

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2059

Can group functions be used in the order by clause in oracle?

997

What is a database table in oracle?

1021