In Dialog program Syntax of Synchronous and Asynchronous?2 5260
what is eqult Hide?4 7202
Give the syntax of Inner,outer Join?"7 24728
How to insert data in ternal table?4 8755
what are the events in Module pool Programming?18 57034
How you prepare documentation?2 9792
VVVV.Urgent- How can i develop more than 30 interactive lists in reports.4 7107
what is a cluster directory in abap hr.how can we read a cluster directory1 3470
What is the difference between macro and subroutine?8 93817
What is the maximum value for Line-Size in the Report?5 14236
how to process the idoc?2 5461
what is the diffreence between sap memory and abap memory plz give the example4 8398
the control commands in the report program are atfirst,atnew,atlast,atend of and what is the difference between them3 5620
how to issue the tickets in support project?1 7068
Overlapping and splitting, where do you assign?
if we are updating a database using thread, and mean while application crashes or thread being aborted then what will happen in Database? Rollback or Database will be updated? Please explain with different scenario.
what is the role in sap security?
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 is scupper?
who is your famous personality
What happent when a AC motor(no break and starters ) stop and suddenly start . ? Starting current low or high?? Why?
DNA binding by proteins with the helix-turn-helix (HTH) motif does not involve a) altered stacking of the DNA at the center of symmetry. b) hydrogen bonds, salt bridges, and van der Waals contacts. c) interactions with base pairs in the major groove of DNA. d) interactions with the sugar-phosphate backbone of DNA.
List down the basic characteristics of cloud computing?
If there is non reproducible bug which developer is not ready to agree, how you will convince him.
what are the expectations of QA from unit level testing
is there any better model than jcb 3dx
What are the Advantages of Laravel ?
How to do and Apply Themes to Datagrid,Lable,Textbox,etc., in C#.NET 2005 Windows Application? (like who we will do themes in ASP.NET using .CSS and .SKIN files). Urgent!!
What is meant by probability density function? a) Probability distributions b) Continuous variable c) Discrete variable d) Probability distributions for Continuous variables