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

how to get the second max val for every group in a table

Question Posted / indu

Answer Posted / indu

select max(sal) from salary where sal NOT IN (select max(sal) from salary)

Is This Answer Correct ?    9 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the duplicate rows count from employees table in oracle?

1067

What is private procedure oracle?

996

What operating systems are supported by oracle database 10g xe?

1018

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2253

Explain what are the different type of segments?

941

What do you mean by merge in oracle and how can you merge two tables?

934

interview questions with answer for cts

2569

How can we create the complete backup of data in the oracle.

2135

What is an Oracle Instance?

1105

How many file formats are supported to export data?

1195

What is different types of joins?

1007

What is the difference between translate and replace in oracle?

1148

What is oracle data type?

942

How can I create database in oracle?

995

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2325