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

what are differences b/w EIA 449 and EIA 530?

0 Answers  


HI frds,,,am final yr IT student.. i secured 81% in x 55% in xii 87% in Btech upto last sem (no standing arrears..) i dt kw clearly abt MNC eligibility criteria.. i heard tat TCS hired 1y abv 60% 1y..so pls help me.. wic cmpnys r anouncd 55% may eligibl in 2011??? pls rly me clearly and sugst som of d compny names...

1 Answers  


Can main() function can be made virtual?

0 Answers  


10. Write a program in ā€˜Cā€™ language that will perform the following operation on double link list. Each node of this list contains the address of previous as well as next node. The previous pointer of first node & next pointer of last node should contain null. 1. Creation of list with as many records as user want 2. Search a node in the list 3. Deletion at last position 4. Display 5. Exit Create separate functions for each operation. The create () will be used to create the list. It should accept no argument & return the address of the starting node. Search() will search a node in the list. It receives rollno as argument & return that node if found otherwise return null. The delete () function will delete the last node. It does not receive any argument & return structure type value at last position. The starting node of the double list must be declared as external pointer variable. Each element of double link list will contain the following information Roll No, Std Name, Course. Use do-while loop & switch case for generating the above menu. The format of the output should is given below: S.No. Roll No. Student Name Course 1 cse01 Anil Singh B.Tech

0 Answers  


c ka base kya hota hai? what is communication?

0 Answers  






Write a test case plan for a typical banking application which involves functionalities like Balance enquiry, deposit, fund transfer etc. Make your assumptions and mention the same in your answer sheet.

0 Answers  


friends help me..am a btech fresher.. wt is the eligibility criteria for TCS???? like %...repli me clearly from x onwards..

0 Answers  


How would Nvidia increase the core clock speed anymore?

0 Answers  


Hi l, I want to install a water purifier (UV) at my home. the distance of water purifier from water tank [1000 lt ] is 7 ft. Is it sufficient for electrical water purifier? I want to know what is the water pressure from 1000 lt tank (the pipe used from water tank to machine is of inch 1-1/4") please note minimum water pressure is required for UV is - Water Pressure Min: 0.4 kg/sq. cm.Max: 2.0 kg/sq. cm. Please advise me on the following: 1) What is the water pressure generate in above condition. 2) What is the required height from the UV machine to water tank for the above condition? Thanks is advance.

0 Answers  


compare the conditional operator with if-else-if statement.

0 Answers  


is there increase in the pressure of water or the density of water if we go deep into the ocean.(but the density of water is 1000kg/cubic meter)?

1 Answers  


what is the differnce between pri and bri

2 Answers   ABC,


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)