Is inner join faster than left join?

1306

HiFriends can you all pls help me in providin me with the answers 1 In which table we store Leads? 2 Types of issues in support?

1976

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?

2599

What are the different SQL Server Versions you have worked on?

1108

Hi friends I have experience of 6 months in website design and maintanence. Now i am looking for other IT jobs.. to switch platform. please post any interview you know in chennai.

2307

How to record the desktop application in Loadrunner 12.53 version 64 bit window.

2351

What is MFN? What is Gold Standard?

1331

Question on maha cement

834

what are the main points to be included in our introduction when asked in hr...??

2075

HI ,MY QUALIFICATION B.A. + PGDCA AND TRAINED ON JAVA . NOW I WANT TO KNOW TO GET JOB SOON WHICH COURSE I HAVE TO LEARN ?

2174

Explain one difference between tableau and other traditional bi tools

467

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2157

Tell us about your Educational background?

1285

Hi friends,anybody can send me previous HAL interview question paper OR all other interview question paper. To, yogeshnature@gmail.com

2212

How job tracker schedules an assignment?

505