Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

NTPC Interview Questions
Questions Answers Views Company eMail

What is the rating of your substation and what are the different types of substations?

5 30378

What is meant by Resonance what are the different types of resonance and what are uses of them?

14 38866

how the aspirator pump works?

1 5202

how to caluculate buoyant force in accelerating fluids?

3 6542

what are black holes?

1 4445





Which modulation scheme are having constant energy modulation?

1 7138

In terms of electrical enhineering, give a detailed explanation of the "earth fault loop path"

1453

what is the difference between impulse and reaction turbines ?

40 95628

what is the difference b/w winding insulation class and winding temperature class?

6 14815

A man leaves office daily at 7:00 pm. A driver with car comes from his home to pick him from office and bring back home. One day he gets free at 5:30 and instead of waiting for driver he starts walking towards home.In the way he meets the car and return home on car. He reaches home 20 min earlier than usual.in how much time does the man reach home usually... ?

8 11292

when does sedimentation occur before filteration, along with it, along with chlorination, after chlorination?

8 10504

what is SAS/Graph?

1 8809

hi i m an EC engg i had cleared written test for PE for BEL plz help be for interview provide me full information about intrvw as much as u can.. thankx..

14 18119

why the generating voltage in India is 11kV or why is it be transmitted as multiples of 11

34 101686

why free wheeling diode is connected across inductive load

16 47672

Post New NTPC Interview Questions




NTPC Interview Questions


Un-Answered Questions

How to switch off predictive text?

197


What is virtual directory in asp.net?

208


Where we get good training and LABS facility In C#.net courses in Hyderabad, I completed the classes in Peers even though im sure in good practice to get right position in jobs please help me who no well in this field?

1308


What is singleton pattern and where we can find it in angularjs?

204


What are the blocks? How will you use them?

1






What is the difference between transaction and transaction instance in loadrunner ?

453


Which method is executed if space is passed for the method parameter of macro swc_call_method ?

207


What is different authentication mechanisms used in ASP.NET?

316


What distributed application?

148


How whitening toothpastes work?

224


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

1355


What is early binding?

219


How can you quickly find the number of elements stored in a dynamic array?

239


how options are different than equities?

272


Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

484