Interested to Buy Any Domain ? << Click Here >> for more details...
Which of the following non-banking finance companies is not allowed to convert itself into a Bank? 1 Kotak Mahindra Finance Ltd 2 Birla Mutual Funds 3 Peerless Finance 4 Tata Finance
2 5666Post New Indcap Interview Questions
What is capacity on demand?
who was the founder of tcs? Who is the current ceo of tcs?
What is the difference in fields in User or Team owned Entity and Organisation Owned Entity?
How to drop database in apache tajo?
What is the performance of the ADSL WIC?
What is the purpose of calling clientcontext.executequery()?
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 the relationship between web dynpro and sap enterprise portal? Are iviews and web dynpro competing technologies?
What is the use of generics? When was it added to the Java development Kit?
How would you propose to advertise your drug?
What propositions should be kept in mind while working with debtors turnover ratio?
What are the android activities?
What is the current major version of bootstrap?
hai friends i have BSNL JTO exam on next month so if any body have model question paper or give preparation tips to my mail id kumar4486@yahoo.co.in this will helpfull for my future .plz & thank u by kumar
When you install SAP SRM application, what technical components get install with SRM software?
