What is Trade Recovery Estimate and how can we calculate it?
Is there any procedure for amendment of power? If Pl. X-Plane?
What the difference between the SoapUi utility and the VS2008 test functionality used for the Web-service testing?
234 MVA Generator 3 phase Short circuit current Values required? Gen set Rating-234 MVA, Gen Voltage-18kv, PF;0.8, Xdv:23.5 %, Transformer Rating-18/380KV, 680MVA,Yndd1 two winding, Step up TR, ZT:35.50 %,X/R 4.33 Gen CB Position, CB open ,Disconnected open, Generator Running Voltage 18 Kv, Bi mistakes generator side earth switch Closed during that time short circuit current level in 3 Phase required, and how to test on site 234MVA Generator Short circuit current,
I have iti elec, 1st aid, and 5 yrs experience in 7.5 mw power plant. Am i eligeble for 11kv license in telangana state..when, how to apply for that.?
when we connect the capacitor banks in series with the circuit? 2 144 pH is having unit?
While testing a ZCT what parameters have to check or measure?
explain about unit testing? in real time?
authorization issue. We had asssigned company codes 'BUKRS' in range for example 4000-4220 some come company code is working some are not working means in between ranges . could you please post the answer as early as possible.
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
Can a formula column referred to columns in higher group ?
The Project Management Knowledge Areas: A. Include Initiation, Planning, Executing, Controlling, and Closing B. Consist of nine different areas that bring together processes that have things in common C. Consist of five different processes that bring together phases of projects that have things in common D. Include Planning, Executing, and Controlling processes as these three processes are commonly interlinked
What is RAC?(Real Application Cluster).Explain in Detail.
What is WP1 Sequence?
In call centre which types of calls we receive? answer in short.