1)why do you select bpo industry? 2)why you left your previous hotel industry? 3)what do you know about this bpo industry? 4)Are you intrested to work in this industry?
30011 chocolate cost is Rs.1 & if we return 3 wrapers(covers) of chocolate we get 1 more chocolate. If u have Rs.15 how many chocolates do u get...?
54 121739Hi,My husband is approved for H1B visa and he needed to book for interview on September to go in October. He was once rejected B1 visa on March same year but we lost the paper and do not exactly remeber the reason of rejection but we know that it was because there was no enough ties for him in the UK and they were doubtful about if he would come back or not. If we cannot provide them the right reason, will they reject our visa. We have only got the papers which say that his H1B visa is approved.Please reply. Tina
2428what is the difference between main meter CT and check meter CT?and what is the difference between main meter PT and check meter PT?
2 15457Post New Tesco Interview Questions
Explain what is the difference between angularjs and backbone.js?
How to access an external javascript file that is stored externally and not embedded?
How do you define view in backbone.js?
Explain differential cost.
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 authentication modes does sql server support? : sql server DBA
Is hashmap thread safe?
How is machine learning implemented in spark?
What is pure monopoly in marketing sales?
1. what is debenture? 2.Why company will issue shares? 3. What is audit? 4. What is the role of finance department? 5. What is mutual fund?
What are the limitations of reactjs?
What is the maximum no. Of rows tableau can utilize at one time?
What is web administration in blue prism?
How to define a named function in JavScript?
Which is the most stable version of angular?