from compund pka value how to select buffer and column?2 6569
Why we use Caffeine in hplc calibration2 9910
Definition of beers_ lamberts law4 3262
what is tax avoiding?
Describe the procedure for isolating endothelial cells from mouse lung?
I have created value contract with order type WK1 in VA41. The target value is 500 USD and the net price is 1000 USD. There was no pop up message or error thrown while saving the contract when the net price exceeded the target value. And the system allowed to save the contract. Is there any configuration available to activate the warning or error message or any enhancement need to be done?
I am a service man.I want to submit my income tax return by efilling.Anybody can help me to do the same with the information to submit the file?
Sir, we are manufacturer of splitter machine. we joint two knifes with welding electrode, BEST ARC, and ADOR, Grade E6013. but the time of welding the welded area comes to wear, what meterial(Electrode)is suitableto our requirement.this knife is press with Hydraulic operation.
someone plz plz plzz.. send me the sample papers for SBI clerical xams... i need it very badly..
Pl. Brief about DNC.
with 3 phase board on a 63 amp rcd is it ok to have 6 electrical showers 2 on each phase and what problems could happen
what are the types of provisions that you would make for the end of a financial year?explain
Explain Reliability Mechanisms in JMS?
What will happen if i used 11KV earth ht kit to 11 KV / 11 KV cable termination?
Give the balance sheet schedules ,what is differe tax, GIVE THE RATES OF DIFFERED TAX FOR THE YEAR 2008-09
n rounds will be there in IBM voice based non-tech support?
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
If UG power cable both ends are to be earthed or what? If not why?