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


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

Post New Answer

More Engineering AllOther Interview Questions

Write a program using string fuctions that accepts a price of an item and display its coded value. The base of the key is: X c o m p u t e r s 0 1 2 3 4 5 6 7 8 9

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  


If you are using C language to implement the heterogeneous linked list, what pointer type will you use?

3 Answers   TCS,


I'm currently placed in Lahore Pakistan. where can i do Microsoft certification. let me know the best place to do.?

0 Answers  


I found that there is no display on monitor even after the cpu have done its booting succesfuly....VGA port is normal and RAM was also been checked. What may the problem...please guide..thanks.

1 Answers  






explain inflation ,deprication ,time of value & pf tariff

0 Answers  


real time examples for basic concepts in oop

0 Answers   Wipro,


can i clearly know courses under oracle

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  


void main() { int i=5; printf(“%d”,++i++) }

2 Answers   Josh Technology,


Explain the memory reference and register reference instructions as micor operation.

0 Answers  


Why is not creat swap partition in my system.

0 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5085)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4451)
  • Electrical Engineering Interview Questions Electrical Engineering (16632)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)