How to use group functions in the select clause using oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Can select statements be used on views in oracle?
How to Select second Maximum salary in a Table ?
How do I learn what codesets are available in oracle?
How to delete a column in an existing table in oracle?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
What is RULE-based approach to optimization ?
can u call user defined functions in select statements
What is difference between SQL and SQL*PLUS?
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
6. Display the client name and order date for all orders using the traditional method.
How to rename an index in oracle?
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?