Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


This question asked during interview,

2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level.

The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month.

The tables contain the following fields:
name data type description
account text account number
registered boolean indicates whether the account is registered
num_trans integer number of transactions made during the time period
spend numeric(9,2) total spend during the time period

a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009.

b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010


not sure what is correct answer and how to solve?

Question Posted / daveriya

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

How to convert a unicode strings to non-unicode strings?

0 Answers  

Is null in sql server?

0 Answers  

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

How can you fetch alternate records from a table?

0 Answers  

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

What are xml indexes?

0 Answers  

write coding for importing sql data into a word excel...

1 Answers   Oracle,

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

What is perspective, have you ever created perspective? : sql server analysis services, ssas

0 Answers  

For more SQL Server Interview Questions Click Here
Categories