how to count 4 column with two "and" condition in oracle? e.g task

how to count 4 column with two "and" condition in oracle?
e.g task_type and cust_type and service_type are 3 column
and we hv to count where task_type="new"and cust_type="jdp"
and resulting column name will be new cust with jdp..and also
we hv to count where task_type="new"and service_type="fs"
resulting column name will be new cust with fs..

Question Posted / vinaysawant1110

0 Answers
1780 Views
I also Faced
E-Mail Answers

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

Post New Answer

More Engineering AllOther Interview Questions

The factorial of a nonnegative integer n is written n! (pronounced “n factorial”) and is defined as follows: n! = n · (n - 1) · (n - 2) · … · 1 (for values of n greater than to 1) and n! = 1 (for n = 0 or n = 1). For example, 5! = 5 · 4 · 3 · 2 · 1, which is 120. Use while structures in each of the following: a) Write a program that reads a nonnegative integer and computes and prints its factorial. Use the following function prototype to calculate factorial: int myFactorial(int n); b) Write a program that estimates the value of the mathematical constant e by using the formula: Use the following function prototype to calculate e: double myE( ); Hint: Use an accuracy of 10 terms. c) Write a program that computes the value of ex by using the formula Use the following function prototype to calculate e: double myEx(int x);

2 Answers

which of the following is not a storage class specifier in c?

1 Answers Infosys,

Explain how a TP Monitor manages memory and processor resources more effectively than a typical operating system.

1 Answers Infosys,

1. Describe a time when you anticipated potential problems and developed Preventive measures.

0 Answers Strad Energy,

how the class is instance of object?

0 Answers

THREE IS EQUAL TO FOUR

2 Answers InterSolution,

what is technical voice process and define it