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?
2010Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 8119hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
7 11913What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 71502) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
2 4010Post New TCS SQL Server Interview Questions
How do make a bibliography?
How would you go about verifying the network name that the local_listener is currently using?
How to use regular expressions in selenium?
What is the numeric promotion?
what was the highest point of your college life?
What is the use of "$?" Sign in shell script?
How will you rate your communication skills and technical skills?
Explain a Computational Graph.
What if i’m running a much older version?
What are the causes of I.O. high temperature in a diesel engine?
Difference between Plug-in Vs Workflow?
What is jpa project?
What are the App states in iOS operating system? Explain them
Is domain privacy needed?
Is rxjs the same as react?