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?
2007Consider 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 8101hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
7 11869What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 71332) 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 3993Post New TCS SQL Server Interview Questions
What tableau desktop is?
What is the alternate way to click on login button?
public static void main(String args[]) describe it
What is the difference between setImmiediate vs nextTick?
Explain difference between cap and pcr ?
public class ActionDTO extends GenericDTO implements Serializable,Auditable { // default serial version id, required for serializable classes. public static final String ACTION_SUSPEND = "SPN"; public static final String ACTION_DEREGISTER = "DRR"; public static final String ACTION_REINSTATE = "REI"; private static final long serialVersionUID = 1L; private Long actionId; private long accountId; private Date actionDate; private String actionType; private String remarks; private AccountDTO account; public ActionDTO() { } public ActionDTO(Long accountId, String action, String remarks, String updatedBy) { setAccountId(accountId); setActionType(action); setActionDate(new Date()); setRemarks(remarks); setUpdatedBy(updatedBy); } public Long getActionId() { return this.actionId; } public void setActionId(Long actionId) { this.actionId = actionId; } public long getAccountId() { return this.accountId; } public void setAccountId(long accountId) { this.accountId = accountId; } public Date getActionDate() { return this.actionDate; } public void setActionDate(Date actionDate) { this.actionDate = actionDate; } public String getActionType() { return this.actionType; } public void setActionType(String actionType) { this.actionType = actionType; } public String getRemarks() { return this.remarks; } public void setRemarks(String remarks) { this.remarks = remarks; } // bi-directional many-to-one association to AccountDTO public AccountDTO getAccount() { return this.account; } public void setAccount(AccountDTO account) { this.account = account; } @Override public String toString() { // TODO Auto-generated method stub return null; } } what is the purpose of @Override public String toString()...and what will do here ?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Is windows 10 being discontinued?
What do you understand by overdraft?
how to test on design and style in software?
Differentiate between singleton and prototype bean?
What is c++ map?
What is roc curve?
What does runstats do in db2?
Define partial class?