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

i have applied for junior engg. signal II please send me questions papers for it

0 Answers

question no. 4======Give a brief description of the following terms: a) Play head b) Symbol c) Tweening d) ActionScript e) Frame rate f) Library panel g) Masking h) Context – sensitive Property Inspector i) Bandwidth Profiler j) Frame Label

0 Answers

Explain Belady's Anomaly.

0 Answers

what is the ans of prefix formula - + / 16 ^ 2 3 * 10 4 * 16 3

0 Answers

What is the difference between Huawei 5700 switch and 5300 switch?

1 Answers Huawei,

how to convert postfix notation into prefix in data structures. please send me algo of taha

0 Answers

what is typa casting and type conversion ?

0 Answers

Please if anybody have Vizag Steel Entrance exam papers or atleast Pattern of exam.Then please forward to my email- id: :srikanth.avanthi@gmail.com

0 Answers

who is the judge in case of the auditor has raised an NCR against an auditee? who should decide weather this NCR is acceptable and the auditee has to accept?

0 Answers AES,

DVC2000 performent: travel ??? and not output signal

0 Answers

What are mixers used for?

1 Answers

what does complexity means in an algorithim?? how it is calcutaed?

0 Answers

For more Engineering AllOther Interview Questions Click Here