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
1328 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

How small can you make a computer? What are the limiting factors?

0 Answers

what is the need to take testing as a carrier?

2 Answers

what is means of admistrative distance

0 Answers

Problem:Design and implement a class that allows a teacher to track the grades in a single ourse.Include methods that calculate the average grae, the highest grade, and the lowest grade.Wrute a program to testyour class implementation in a c#. given grades:integral=85, physics=87, datastruct=84.

0 Answers

why need of new operator in java why not in c++

0 Answers

sir i have 4 year gap in engineering. i would complete my degree b.tech it in 2014. it will be may be in 2nd class.my hsc is also with 2nd class. i am week in programming. Then if i want highest package upto 5-6 lacs then what should i prepare myself as a good engineer to get this package???

0 Answers

Explain what are db_options used for?

0 Answers

plz snd me sbi probationofficers papers to my id archpa@gmail.com

0 Answers

explain inflation ,deprication ,time of value & pf tariff

0 Answers

. There are two water tanks A and B, A is much smaller than B. While water fills at the rate of 1 liter every hour in A, it gets filled up like, 10, 20, 40,80, 160…..in tank B. (At the end of first hour, B has 10 liters, second hour it has 20 liters and so on). If tank B is 1/32 filled of the 21 hours, what is total duration of hours required to fill it completely?

3 Answers TCS,

hello everyone, one thing thats giving me a headache..hope u guys will help me out.i recently gave my gre and got extremely low marks. my gre score is 980 , enginnering aggregate is 58% , diploma aggregate is 73% , 10th score is 79%.so d big question is , is der any possibility of getting admission in any average US university ? am in a turmoil, Please help me out.Thanks in advance

1 Answers

i have an interview in Qatar Petroleum. So please provide the all details abt safety management

0 Answers Qatar Petroleums,

For more Engineering AllOther Interview Questions Click Here