Mention any 5 best SCM practices?2 6519
what is the difference between operating system shell and clearcase shell?1 7045
what is eclipsed file in clearcase? What is the solution? In what case it is called eclipsed file?4 27983
What is the advantages of using clearcase tool instead of sharepoint with regards storing files?4144
How many aditional groups can be added in vob? How many for 32-bit? and how many for 64-bit OS?2 6449
What is the deffrence between TCP and UDP?1 5510
What is the default size of a brand new vob?2 7969
Where do u specify the license host details when u setup the Clearcase for the first time?2 6465
how to list all the co's by a user in different vobs through a single command2 5721
what is differences between mvfs and ccfs in clearcase.1 8333
What is the basic PC architecture (main components)?
Sir when will the SBI Associate bank PO Exams results will be released .which the the exam held on 7 th Aug 2011.
What are Anonymous Calls?
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
Pls guide me to choose to MM cource (SAP) in Mumbai or N. Mumbai
Which kind of agent architecture should an agent an use? a) Relaxed b) Logic c) Relational d) All of the mentioned
What are the advantages of new LO extraction?
I am getting above 60 V as open delta voltage against single phase unit ICT at tertiary delta formed and ICT getting trippped on NDR. ICT tested and found in order. PTs provided on tertiary are tested and in order. what may be the reason?
What is a one-time-pad?
How are fishing communities affected by emergencies?
I am not sure about the syllabus of the BHEl esam for the post of Engineer trainee so I want to know it and also send me model question papers
How to set up valid email address and printer in Cognos, so can delivery the report by email or print it out?
What is the difference between Generator Differential Relay and Transformer Differential Relay?
(b) Describe how to safeguard a system through acquisition of an antivirus Program and systematic backup.