why capacitor bank always connected in delta,why not in star to a system?15 61549
What will be the direction of rotation of a Alternator in case it goes in motoring action when connected with grid ?6 7601
what is the advantage and disadvantage of billing in kwh and kvah by electricity board .6 29282
What is the first settlement authorty in ID act1 2864
what is specific gravity of a battery if specific gravity increase/decrease,what will happen to the voltage/current of the battery5 5636
why do you want to job in ntpc1 6756
WHAT IS THE DIFFERENCE BETWEEN EARTHING AND GROUNDING?1 1504
tan delta test of current transformer.3 11658
How do we measure earth fault current in Generator Transformer(20/420kv),Station Transformer(20/11 kv) and Unit Transformers(20/11kv) for our plant system, since these don't have any Neutral earth Fault relay connected to their Neutral Earth? But for Unit Service transformers(11/.433 Kv) we have an Earth Fault Relay connected to its neutral earth.Why is such so?1 2790
if a member of mass 100 gram travelling with 10 m/s hit another body,and the final velocity is 59 m/s.what is the mass of second member4 3002
what are the names and size of various conductors used in transmission lines1 6949
what is waybill key number & how can it be issue?
Pease send Quantitative Quantitative Aptitude Question
What is the Use of the inet_makeaddr() Function?
in control panel, how can i measuring the distance between one bus bar to another bus bar. then now only for bus bar. in mpcb and contactor also. that means one mpcb to another mpcb how much distance? how can i calculate that.
What is color sensitivity?
what is a rate controlling step ? how is it dependent on reaction path ? explain with an example.
what is activex controls in qtp
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
___,___ arguments will be used to run a executable program in shell function
What is the use of ActiveX Documents?
What are the different states of STP?
Hi, I am new in oracle(SQL), could anyone help me in writing a correct SQL. Below is the table structure. Table: Subsc Fields: 1. Sub_no (this field will hold values of subscriber nos, for e.g. S111111, S222222, S333333, S444444, etc.) 2. s_status (this field will hold values for different status of subscriber, for e.g. 'A', 'S', 'C', etc.) 3. cus_id (this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) Table: Bill Fields: 1. Bill_no this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) 2. b_status = (this field will hold values for different status of bill for e.g. 'O', 'C', 'S', etc.) Note: 1. The Sub_no is a Primary key of Subsc table. 2. The cus_id is a foreign in Subsc table (referred from Bill_no field of Bill table) 3. The Bill_no field is the Primary key of Bill table. Query A --> I wrote a query to select cus_id/Bill_no which is in status open (b_status = 'O') and having more than two active subscriber (i.e. S_status = 'A') in it ( i.e. more the two subscribers in same bill). select s.cus_id from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id having count(sub_no) = 2 Problem : The above query will give the cus_id (or rather bill_no) which are in open status (b_status ='O) and which are having TWO ACTIVE Subscribers (s_status ='A') in it. However, this query will also lists the cus_id/bill_no which are having more than TWO subscribers in it (but only two subscriber will be in Active status (s_status = 'A') and the others will be in s_status = 'C' or s_status = 'S'. Help needed: I want to write a query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it. B--> If I include the sub_no in the above query then NO row are returned. select s.cus_id, s.sub_no from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id, s.sub_no having count(sub_no) = 2 Help needed: I want to modify the above query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it ALONG with the sub_no. Thanks a lot in advance. Regards, Nitin
How fast is RSA ?
plz give sample question paper of hpcl thank you firstname.lastname@example.org
How to identify column in VSFlexgrid? My VSFlexgrid window is identified as 'Active X Control'