How to use group functions in the select clause using oracle?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

Can select statements be used on views in oracle?

0 Answers  


How to Select second Maximum salary in a Table ?

13 Answers   Oracle,


How do I learn what codesets are available in oracle?

0 Answers  


How to delete a column in an existing table in oracle?

0 Answers  


Design database draw er diagram for a certain scenario ?

0 Answers   Keane India Ltd, TATA,






What is RULE-based approach to optimization ?

1 Answers  


can u call user defined functions in select statements

2 Answers  


What is difference between SQL and SQL*PLUS?

1 Answers  


how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  


6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,


How to rename an index in oracle?

0 Answers  


I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)