Query to get max and second max in oracle in one query ?
- 34 Answers
- 60402 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sumit wadhwa
select distinct(a.colname) from table a where &n=(select
count(distinct(b.colname)) from table b where
a.colname<=b.colname);
from this query u can find out Nth MAX in a one query
eg
select distinct(a.sal) from emp a where &n=(select count
(distinct(b.sal)) from emp b where a.sal<=b.sal);
| Is This Answer Correct ? | 55 Yes | 16 No |
Post New Answer View All Answers
What is data file?
Is it possible to split the print reviewer into more than one region ?
What is the difference between "as" and "is" in an oracle stored procedure?
How to connect ms access to oracle servers?
What are the tools for Oracle ?
Difference between pre-select and pre-query
How much memory your 10g xe server is using?
What are a query and state the different types of queries and their uses?
How do I know if oracle is installed on windows?
What is rowid and rownum in oracle?
What is the use of aggregate functions in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to convert characters to numbers in oracle?
How to run the anonymous block again?
How to export data with a field delimiter?
