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

Answer Posted / answer

NO NEED TO WATCH ANY OTHER ANSWER .ANSWER 11 IS GOOD.JUST
GO WITH IT

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Will you be able to store pictures in the database?

642


How would you begin to troubleshoot an ORA-3113 error?

1605


What are advantages of dateset in datastage?

1748


How to use "in out" parameter properly?

614


Can we insert data in view oracle?

537






Can we connect to ORACLE db using Windows Authentication?

722


What is the difference between translate and replace in oracle?

656


How can you merge two tables in oracle?

567


what are archived logs?

1717


State and explain about oracle instance?

551


What is the relationship among database, tablespace and data file?

542


Explain enable novalidate constraint.

597


Explain the truncate in oracle?

549


What are the different types of modules in oracle forms?

562


List the various oracle database objects?

599