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

How to create a stored function in oracle?

593


How to Truncate Table in Oracle

657


How to assign values to data fields in record variables?

584


What is a static data dictionary in oracle?

574


Explain the use of analyse option in exp command.

590






What is oracle analytical function?

531


Explain the blob datatype?

620


Please explain joins in oracle?

549


How to export data to a csv file?

627


How different is ms access and oracle?

547


what is dynamic SGA and static SGA

3845


How to name query output columns in oracle?

692


Explain do view contain data?

585


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

570


How to grant create session privilege to a user in oracle?

574