for example,

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

for example, for jan

bank1_200901

bank1_200902

i have deadline on monday and if i dont complete it ,i will be fail.

i am just asking yes or no.

i am doing my own,but i want to make sure...

what about particular day,i should add where condition.

thanks

hi

select convert(varchar(20),username), logindate

from logs

group by userid,convert(varchar(20),username),logindate

having count(*) > 1

i tried this,but dont understand group by it is necessary to have 3 column in this query

This is not working

select username from logs group by logindate having COUNT(*) > 1

logindate is already date datatype,

its gives me error like

Column 'logs.username' is invalid in the select list...

But i am getting result,whats wrong in this?tell me

2(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

...

hi,

its working ,thanks a lot.

i m trying to solve another one based on that,but thanks a lot

i tried sunquery,i cant join them coz i think there is no pk->fk releation between them.

nothing is worked

i dont understand you this is not working.

write some query and show me.

this givesme result in 3 rows.how cam i make it subquery

i know , i need to solve this on my own,

i solve first one,but in the second one

Write a SQL query that will display the total number of...