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
1746 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 are the qualifications for a cse student to get government job

1 Answers

what is PPM,CM & EM in FM company

1 Answers

can oracle driver be directly connected with odbc driver??

0 Answers

What is the allowable load carrying capacity of a circular column section of 400 mm diameter reinforced with 6x25 mm diameter bars adequately tied with spirals? Consider concrete of grade M25 and steel of grade Fe 415.

0 Answers

What is JVM and its role? What is the feature of platform independency in Java? How does it differ from C++?

1 Answers Impetus,

find the next number:60 24 7 4

1 Answers

Hi Friends, I am doing engg in comp sc in the final year from the evening college, I don't have experience in technical field. I am working in nontechnical field. I have big question that will IT companies considered me as fresher or they looks experience from me ? if you reply to my query, i am really grateful to you

0 Answers

Hi i was appered the ISRO written test conducted on 26-Apr- 2009. I want to know the date of results. Please anyone tell me the date

2 Answers

my first question in huawei was ....1)Tell me about your self 2) oops concept 3)logic gates 4)ram and rom ,what is cache memory nd where it is located 5)diffrence between file system and data base 6) procedure of operating system 7)what is c# 8)high level language and machine language 9) and from mobile networkin !!!! hope thz will help you

0 Answers Huawei,

Explain different parts of an instruction. What does the addressing mode bit specifies?

0 Answers

How to select the total numbers of fire extinguisher installed in a room ?

0 Answers

How can I get know that my pc contains dram or sram..?

0 Answers

For more Engineering AllOther Interview Questions Click Here