Mr. S. Rajendra Babu, who is the _____ authority in the premier office of Indian judiciary, belongs to Karnataka. (a) Highest (b) Second highest (c) Third highest (d) Fourth highest
2 5217The greatness of Sher Shah lies in his (a) Victories against Humayun (b) Superior generalship (c) Administrative reforms (d) Religious tolerance
16 48468The doctrine of Lapse was introduced by (a) Lord Hastings (b) Lord Wellesley (c) Lord Dalhousie (d) Lord Bentinck
11 30378The first conference of Indian National Congress was held at (a) Bombay in 1885 (b) Madras in 1886 (c) Calcutta in 1885 (d) Madurai in 1887
4 13277The author of Anandmath is (a) Rabindranath Tagore (b) Bankim Chandra Chattopadhyaya (c) Sarojini Naidu (d) Sri Aurobindo
7 29451Which is the best known bird sanctuary in Haryana ? (a) Sultanpur (b) Bharatpur (c) Rajaji (d) Sariska
3 17171Who was the first Indian to be the President of UN General Assembly ? (a) Natwar Singh (b) V.K. Krishna Menon (c) Mrs. Vijayalakshmi Pandit (d) Romesh Bhandari
10 40317Among the following who was the President of Constituent Assembly ? (a) Mahatma Gandhi (b) Dr. Rajendra Prasad (c) Jawaharlal Nehru (d) K.M. Munshi
5 11940Mica is used in an electric iron because it is a (a) bad conductor of heat (b) good conductor of heat (c) good conductor of electricity (d) bad conductor of electricity
7 24036Post New SSC Interview Questions
What is a wrapper function in c?
Explain the functions of paring disc and flow control disc in purifier and clarifier?
When should I use selenium grid?
Actinium-227 has a long half-life and emits alpha particles. How can this property be harnessed in radiation detectors or other monitoring devices?
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
Explain your experience with soil and water conservation practices and your role in preventing erosion and maintaining soil health.
What impacts will the Internet of Things (IoT) have on Manufacturing Sector?
What is impact analysis? As a tester how will you do impact analysis in your project?
What are the benefits of running processes in the background?
Explain the peer-peer process.
What are converter tags in JSF?
How to upload media use loadrunner? I record the script but it fail because the top of document is invalidation.How to solve the problem?Which one know the answer please tell me. Thanks!
what is stock exchange?
Explain me why do we use msmq?
What Is Difference Between Mapreduce and Pig ?