What is the difference between (with what type of material they are made of)RAM cells and Cache memory cells
2 4311hi!how to write test cases on SRS?tell me any example which type of certification is usefull for less then 1 yr exp. people in testing?
2 9854What is the difference between phase current & line current, how both can be measured in star and delta system
9 80725Write a Program to print this triangle: * ** * **** * ****** * ******** * ********** use two nested loops.
12 25902What are the types of windings present in the ceiling fan? What winding will be effective first when we started the fan?What are the resistance and inductance ratios comparatively at the initial speed and full speed of the fan?
2437If i have faced a trial in home country but was later acquitted and found not guilty of the offence, so should i mention this matter at time of visa filing or not. If i dont mention it and obtain a Police clearance certificate, can this matter resurface at time of applying for Permanent residency in New Zealand?
1862Post New MIT Interview Questions
using only #include
Can I use node js with php?
Is learning c# hard?
How do you remove lines from a table?
What is the use of now constructor in perl?
What are the advantages of jQuery?
What is ripple effect?
What is the difference between Java and C++?
How does output caching work in ASP.NET?
Explain in brief preliminaries of C/C++?
The partition of hive table has been modified to point to a new directory location. Do I have to move the data to the new location or the data will be moved automatically to the new location?
What is dojo toolkit?
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 to invoke Oracle Stored Procedure with Database Objects as IN/OUT?
What do you understand by xml-rpc?