i have got short listed for the inerview in syndicate bank for the post of probitionary officer.i dont know how to prepare for the interview pls help me to face the interview. what are al the things i should concentrate.whether marketing wil b additional qualification for such post pls help me
1460RBI Grade B-Officers Recruitment Exam Reserve Bank of India Services Board, Mumbai July 2009.I want the previous year question papers...?
7 11423i have to apply for the rbi for the post of officers. i need to know abt the entrance questions whether it may be aps or techinical....
1526I would like to have the previous year questio paper for RBI 'B' grade officer examination Mumbai. please help. My mail Id is narmadha.arjun@rediffmail.com
12 12922hi.. i have applied for RBI Grade B Officers post.. still i didnt receive the call letter.. can u help me.. when i will get the letter or else whom to contact and his number to clarify the details Thanks
1510Post New RBI Interview Questions
what are the specifications we must look at to select a relay for any capacity motor?
What is roc curve?
What is the main purpose of java?
what are the various off the job training methods?
What is internet telephony?
How will you make a field mandatory in maintenance notification for a certain notification type?
Write a command that will look for files with an extension "c", and has the occurrence of the string "apple" in it.
How do you effectively communicate complex diagnoses, treatment plans, and potential risks with patients and their families?
What is Debenture Stock?
How to download file in php?
List the major sources of knowledge.
Where to use friend function in binary operator overloading . How? explain with an example.
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
Can we define the size of arraylist?
Why are oltp database designs not generally a good idea for a data warehouse?