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

what is static identifier in c language?

0 Answers

nohup sort employees > list 2 > error out & what will happen?

0 Answers IBM,

Please tell us about an implementation that you worked on that did not go as planned. What were the challenges you faced and how did you overcome them

0 Answers

why we select you?

0 Answers

Based on the Job Description above, please indicate in details why you are a good match for this position?

0 Answers

funtionalities of loadining and linking

0 Answers

what type of questions pannel ask to the intervier? plz i want questions about computer engineering? System security subject.

0 Answers

An inversion is an array of numbers is any pair (i,j) such that i<j and A[i]>A[j]. What is the average number of inversions in an array of n ? distinct numbers?

2 Answers Infosys,

A short CI column of hollow circular section has projecting bracket carrying a load of 10 tonnes. The load line is off the column by 20cm. The external diameter of the column is 350mm and thickness of metal is 25 mm. Find the maximum stress intensity in the section.

0 Answers IIIT,

Discuss the various process operations, clearly stating what is involved in each process operation.

0 Answers

WAP in Java to print the format AMIT M I T

0 Answers

How to trouble of routing protocol like EIGRP and OSPF

1 Answers NetMagic,

For more Engineering AllOther Interview Questions Click Here