how to find the heap size is full in weblogic server?1 3808
how much of quantity of material required for execution of one cubic meter of random rubble masonry in 1:3 cement mortar
About Funding Working Capital to a Company? A company Turn over is 12 Cr, but in the bank statement credits per month is more that 3 Cr? how this could happen? awaiting your views?
What is the maximum amount to issue Form C to a dealer for the purchase of 40 crores in several bills in a quater?
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
what are the common errors while doing integration,system,functional,regression,user acceptance testing? can anybody please let me know the answers it is too urgent???
how to carried out DAR test in 11 KV Alternator ?
What is different between Circuit breaker and Isolater?
difference between f distribution and p values?
general diesel engine we are using 15w 40 oil unfortunatley our oiller mis used the oil hudralic oil refilled when he doing the service which kind proplem coming in future?
Fuzzy logic is extension of Crisp set with an extension of handling the concept of Partial Truth. a) True b) False
Hi Could any one please explain various business scenarios handled in sap.THis was the question i was asked in the interview i explained to an extent but he is not satisfied. Secondly if a person is terminated what will happen to data how long it will be maintained in the master data? Thirdly if a person is in contract is made to permanent what are the transactions carried out? If a person is terminated whether his data is deleted immediately. How long his data will be stored in the database whether it is permanently deleted or not? Pls answer for these questions asap. Thanks Priya
what is locative information on web.........?
What kind of Reporting you do?
The rate constant for the second order reaction is 0.54/M.s at 300oC. How long (in sec) would it take for the concentration of NO2 to decrease from 0.62M to 0.28 M? 2NO2(g) 2 NO(g) + O2(g)
What is difference between oracle 9i and oracle 10g?