Go Back   2021-2022 StudyChaCha > StudyChaCha Discussion Forum > General Topics





  #2  
Old December 14th, 2016, 06:02 PM
Super Moderator
 
Join Date: May 2011
Default Re: Bank Of America SQL Interview Questions

Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets.


As you Asking for the SQL Query Questions for the Interview of the Bank of America the Question Is given below


How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?


TABLE RSVP

Name, Decision, Date
Jon, Y, 1 jan 2016
Jon, N, 2 Jan 2016
Linda, Y, 1 Jan 2016
Mark, Y, 5 Jan 2016
Rob, N, 5 Jan 2016

-- SQL query to find out how many of your friends are coming to party?, make sure that, they haven't said N after saying Y like Jon, check date.
So the answer should be 2


We are given a book with N number of pages and two words. Find the distance(in pages) between the first occurrence of first word and first occurrence of second word. For Example, you are given the book "Thinking in C++" and two words 1. "Inheritance" whose first occurrence is in page 220 and 2. "Polymorphism" whose first occurrence is in page 350, the result would be 130. You can take your decision to choose how the data structure of the book would be.


On January 1, 2007 two new societies S1 and S2 are formed each with n members. On the first day of each subsequent month, S1 adds b members while S2 multiplies its current number of members by a constant factor r. Both the societies have the same number of members on July 2, 2007. If b=10.5n, what is the value of r?
__________________
Answered By StudyChaCha Member
Reply With Quote
Reply


Reply to this Question / Ask Another Question
Your Username: Click here to log in

Message:
Options



All times are GMT +6.5. The time now is 08:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8