A payroll system?
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
If a developer said the bug a QA found is not a bug, what should i do despite having to reproduced the screenshot of the application?
Our firm is 7 years old. We don't have PT registration for partners as well as employee. If we do it now, will it be a problem or how much penalty will come. Any one can give suggestion.
write a compilemodule function for loginscreen.
Distinguish between straight line and diminishing balnce methods in calculating depreciation
We Have Two Field bus Pressure Transmitters of Different Sensor Range (I.E One is of Lower range and Another is of Higher Range).Is same Process Line. My Question is Can i provide Saturation Limit to my field Bus Transmitter as We can provide Saturation current limit to HART Instruments. As During Low Pressure Both Working OK ,But During High Pressure, transmitter with Lower sensor range Goes to Fault mode as Beyond its Sensor Limit it can Measure, So may I provide Saturation point Some where to Suppress This Fault during High Pressure.
why the electrolyte level in lead acid battery is maintained 2.5 cms above electrodes?
what is difference between fluidity and workability also how palsticizer works
hi , anyone plz end nic model papers to my id
Can anyone send me e commerce website test cases please its urgent
detail of mass flow meter pricipal
Hi Everybody could you please send me the ISTQB Material to my mail id firstname.lastname@example.org Thanking you in advance
friends....i have been searching the model paper for HPCL officer trainee for chemical eng....tat apptitude section...if u people got any information regarding tat...please send me to my mail...my id is: email@example.com...pls send me wtever information u knew....thank u....
Hi friends did any budy attend accenture system test for qtp? if any budy pls drop questions.not only accenture any other mnc company which you attended system test(QTP)?it may helpful to others also