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?
What are different elements of wcf srevices client configuration file?
Hello Friends, I am Looking for the Load runner-Performance testing institute in HYD. I see most of them in this site are suggesting for TS Technologies as best institute for PT load runner. We you pls suggest me, Does this institute offers good coaching on Weekend Sessions/Batches? Does it covers all the course contents in these session? Please help me on this guys..
please send me previous year questions of jspl through which i could prepare myself for the test.
a.what products does your firm produce? b.what costs are asssigned to the product produced? c.for particular product,what direct materials are used? d.what percentage of total manufactoring costs is direct labor? direct materials?overhead? e.how is overhead assigned to the products? f.do you now use or plane to use an activity_based management system?why or why not?
can u give me model question papers for exam preparation .
how was your last weekend.
pls ,send me technical questions of jindal steels and power ltd
If anybody has placement papers for igl , plz send to me as soon my exam is on 12 Jan. My mail I'd is navjot.singh800@gmail.com
What sort of serious problems have you experienced, and how have you handled them?
DRDO entrace exam questions for ceptam please forward for this mail.pls immediately
Anyone have sample questions for bhel interview.please send me as Iam appearing for the interview on 19th sep2008. Kindly send this to my e-mail: arun_prasath_n@yahoo.co.in
A steel column 3 m hight is of hollow square section, 200 mm outside dimension and 20 mm wall thickness. (young's modules E=210*10^9) calculate A: the compressive load which will give a stress of 60 MN/m^2 in column. B: the compression o the column under the load in (A).
What is Standard deviation? How it will use in Lr?
HAI SENT HPCL APTITUDE QUESTION PAPER, MY EMAIL ID IS angus_eee04@rediffmail.com,angus_eee04@yahoo.com
