Dear Sir, My qus is my co. purchase a laptop from Abc.co. for rs-37200 on credit Emi basis from hdfc bank. i paid every month 6200rs as a installment. so i want to know how i make a entry in tally 9. and also want to know i creat laptop ledger under fixed assets or office expenses. plz tel me soon.or mail me .
If there is no problem with the electronic circuit and regulator then why the motor start rotating at low value of regulator with full speed both at laod and no load??? and if my judgement of circuit is wrong then what is your openion?
we want build 10ft height ,tostore 4 litresof water.what is theground basement for steel andcement andsand.please send us basment calculation?
How will polarity test of Dy5 Transformer ?
Explain Need of a starter in a dc motor.? Also explain any two starting and speed control method of dc motor?
what is interfacing in computer studies?
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
Hi all i did my M.B.A financ enw iam doing a job as a finance executive but i feel it is not good 4 me can any 1 plz guide me 4 the better career my job profile is (INVOICING)hw it is help me out 4 the better career shell i continu ein the same 1 by learning sap or oracle or shall i shift to any other if any other which job is suites to me plz suggest me
how form h fill up?
How to Send object as message in JMS?
i am preparing for interviews in real time job what test cases we have to prepare please explain with example?
Both the USA and Japan are said to have followed a mechanical technology path in Agriculture development. what are the factors needed on such a path to bring about a successful Agriculture development process for LDCs and why?
What is the mode of the distribution in frequent brightness value?
Sir , i am a Mechanical Engg Student. Pls send me the JinDAL STEELS AND POWER LIMT.. RECRUITMENT DOMAIN AND APTITUDE BASED SAMPLE QUESTION Papers.. JINDAL IS MY DREAM JOB..PLEASE HELP ME AND GUIDE ME TO BE SUCCESS,I NEED THE SAMPLE QUESTIONS FOR URGENT. MY IDfirstname.lastname@example.org.
How would you attach pictures in column headers of List View Control?