Query to get max and second max in oracle in one query ?
Answer Posted / assdads
five times tapping shift key helps to go woth out a mouse
by using number key.you can copy data in form by pressing
shift+insert.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain the use of control file?
How to delete a column in an existing table in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to calculate date and time differences in oracle?
Name the three major set of files on disk that compose a database in Oracle?
What is max rowid in oracle?
What are the different oracle database objects?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to create a single index for multiple columns?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How many types of tables supported by oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
How a database is related to tablespaces?