Find min value of fn: |-5-x| + |2-x|+|6-x|+10-x|; where x is an integer 0 17 23 1911 39398
units digit in expansion os 2 raised to 51 is: 2 4 6 811 44610
A man engaged a servant on a condn that he’ll pay Rs 90 and also give him a bag at the end of the yr. He served for 9 months and was given a turban and Rs 65. So the price of turban is i. Rs : 10 19 0 559 29036
please inform cofigurations path ( back end) for date specifications IT 00413 3737
45 grinders brought @ 2215/-.transpot expense 2190/-.2760/- on octroi . Find SP/piece to make profit of 20% 2585 2225 2670 33254 31472
Boat goes downstream from P to Q in 2hrs, upstream in 6hrs and if speed of stream was ½ of boat in still water. Find dist PQ 6 4 10 none4 23026
Asish was given Rs. 158 in denominations of Rs 1 each. He distributes these in diff bags, such that ne sum of money of denomination betn 1 and 158 can be given in bags. The min no. of such bags reqd :2 13869
.There is a rectangular Garden whose length and width are 60m X 20m.There is a walkway of uniform width around garden. Area of walkway is 516m^2. Find width of walkway: 1 2 3 411 37692
What is alternate function for clrscr().5 8250
2x-y=4 then 6x-3y=?25 18793
Fresh Grapes contain 90% water by wt. Dried grapes contain 20% water by %age. What will b wt of dried grapes when we begin with 20 kg fresh grapes9 20249
plz send me,capgemini placement paper1 4235
The walls and roof of a room are 10 m long,8 m wide and 10 m in height is to be painted.How much will it cost at Rs.5 per sq.foot? A.1600 B.2000 C.2200 D.240010 8954
suspense account willbe transfer to3 8359
Find the ratio of the areas of the regular hexagons inscribed in and circumscribed around a circle of radius 10cm.1 2524
What is javabeans api?
Does wordpress cms allows the use of multiple language to cater regional people?
Explain the function of cooling water expansion tank.
Explain timestemp datatype in sybase.
The way to mix 2 stand out files with same fields however totally different knowledge (different years)?
How to identify the top or popular pages on my website in google analytics?
Name a few data dictionary objects?
How to validate an atom 1.0 feed file?
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 difference between Web 2.0 and Web 3.0?
What is the procedure of submit bank guarantees and cancellation.
Can we use jsx in typescript?
How do you manage outgoing partial payment for vendor in fi?
Tell me have you ever had to negotiate in order to get your way when working in a group? : insurance health