Query to get max and second max in oracle in one query ?

Answer Posted / abcd

for page break or form feed we use following
  /f (char)12
for nbsp;
(char)10  

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

 What are the oracle DML commands possible through an update strategy?

592


How to use subqueries with the exists operator in oracle?

612


What are the advantages of oracle 12c?

565


How to rollback the current transaction in oracle?

549


what is insert all statement in sql

5537






What is the difference between alert log file and tarce file ?

1645


what is the difference between restoring and recovering?

566


What is a system tablespace and when it is created?

569


How to call a sub procedure?

575


Explain oracle data types with examples?

586


Can you tell me how to add new column in existing views?how?How is possible?

948


what is the scenario where you take the database to NoArchivelog mode?

1851


What is the oracle implicit cursor?

606


Can we commit inside a function in oracle?

568


Explain the difference between sql and oracle?

590