What is INBOUND and OUT BOUND? (Different types of interfaces)16 102009
What are profile options?4 8285
What is multi org?6 7983
What are the User PARAMETERS in the Reports?6 10060
What is Value Set?2 16708
What is P2P cycle.27 70920
If there is any issue then whom do you report.(this is imp question for every interview)3 6082
How many phases of implementation and what are those.2 5279
Explain the multi-organization structure.1 6459
What is responsibility and how u attach5 12959
How to create user and how u attach with responsibility.2 4882
What is request group4 18345
What is menu.2 5165
Cycle of requestion to receving transaction.1 4175
How many typres of Purchase order and what are those.2 5039
hi,i just want to know the best institute to learn oracle in bangalore because i am doing my BE there?
How can you Navigate from the DHTML application to another DHTML application? .
Whatis new GL & Odd G.L What is the difference between these two.
• How are basic order dates determined?
How to do Petrifilm?
What are the different losses In a de mac1une'! t.xplam
How to create a bitmap from an icon?
could you please post the Q&A of SAP CRM interview questions and answers on Sales and Service? Pls mail to my email id firstname.lastname@example.org. Shall be grateful for your reply. shilpa
What Folder Structure following in Keyword Driven Frame work?
Please give us an example of a situation where there were competing priorities. What actions did you take and what were the results?
How do you reset the circuit breaker?
what will be the cost of thickness of 125mmor rcc measurement of 52x33.75 feet
How BLObs act as SQL input parameters?
What is the use of localStorage in HTML5 ?
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