why do you want to join our hotel17 85707
why you join the hotel industry?47 209736
why we should hire you?23 33405
WHAT DO YOU KNOW ABOUT OUR COMPANY?8 21451
What are your development areas?7 26560
Have you ever worked with someone that you did not get along with as part of a team? How did you1 20471
what will you achieve for the company if you are employed to work2 8396
why you want to join j w marriott? and tell me about j w marriott property and its owner1 5995
why is the earthing pin on 3 pin top are big and thick3 3905
1 Amp = kva ? 1 Amp =KW ?3 8311
how u measure/calculate renge of capacitor,capacitor has no any rating tag.what is the theory of measure of capacitons.801
have u any web site who can give all electrical sum's to solve counting easy like how to convert 1kw=?Kva.1 1823
which collection enforces type safety?
i am electrical and elctronics engg passed out in 2009 want to attend for reliance placements.plz send me apttitude ,technical and hr question answers to my mail plz. my mail email@example.com
How do moss and lichen affect the ecosystem?
I opened gmail login into gmail and i have to save (Pass or move) all the mail into notepad please give me code Thanks of all
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
During underground cabling in landscape area what did we cover the cable with to prevent the electric shock & protect the cable?
What do you mean by Bracketing and Matrixing in stability?
What are the key features of a Distributed Control System? describing the various layers (sensor through to business system interfaces) as well as the hardware, software and security aspects of the DCS.
VB ActiveX: Create a "drivelist"(D1) box, a "folderlistbox"(FLD1) that changes whenever D1 is changed , and a "FilelistBox"(FIL1) that is populated with the file lists under the selected directory in (D1).The file selected is stored in a variable "filename" along with the path. Question: How to use this activeX control in VC++ to get the selected filename?
steps which are performed in the bios POST codes
What is the difficulty you have faced in the BW in your overall experience?we don't want common things,we need some difficult concepts what u have faced(in past Experience)?
I’m the CEO of a Fortune 500 company. I make more in an afternoon than you make in a year. I don’t care about this stupid security stuff, it just costs time and money and slows everything down. Why should I care about this junk?
what is a pilot wiring and whys that called a pilot wiers
which is the latest version of dos? & what is the command to copy windows files (i386) without formatting OS?
in what type of applications v can use q meter?