sql - COUNT(DISTINCT) in subquery -


i trying retrieve each loan number, count of how many times loan number appears in each month. in cases loan number appears twice in month, want counted once in each month. test , rd columns not giving me need. here have:

select  [month], one, loannumber, two, three, four, ...  count(distinct loannumber) test, count(loannumber) on () rd   tablename lc [month] ='12-2016' group  [month], one, loannumber, two, three, four, ...

please help!

i think need add partition by clause windowing count() expression, , remove group by, this:

select  [month], one, loannumber, two, three, four, ... count(*) on (partition month, loannumber) numberofoccurences   tablename lc [month] ='12-2016'

-

Comments

Post a Comment

Popular posts from this blog

c++ - CPP, 'X' button listener -

i'm writing cpp program, , want execute function when 'x'(shut down) button pressed. for example, have infinite loop prints same thing everytime iterates, until 'x' button pressed, , want execute function before process ends. is there kind of listener matter? or other solution maybe (like delaying process shut down few seconds or something)? thanks! if want execute before process ends, can register std::atexit handler. function called before process exits.
Read more

Get Max value from table in hibernate -

i using below java(1.7) function max value hsql using hibernate 4.3: public int getmaxid() { session session = hibernateutil.getsessionfactory().opensession(); query q = session.createquery("select cast(s.id integer) student s order cast(s.id integer) desc"); list result = q.list(); return integer.parseint(result.get(0).tostring()); } but getting below error: error: unexpected token: ) required: in statement [select cast(student0_.idasinteger) col_0_0_ public.public.student student0_ order cast(student0_.id integer)desc] exception in thread "main" org.hibernate.exception.sqlgrammarexception: not prepare statement @ org.hibernate.exception.internal.sqlexceptiontypedelegate.convert(sqlexceptiontypedelegate.java:80) @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:49) @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:12...
Read more

R: tune.svm return same performance for every combination of parameter -

i have dataset 22 subjects , ~20000 features. want train supporting vector regression nu model linear kernel. in order chose best parameter model using tune function in package e1071 following call out = tune(svm,dependentvariable~.,data=data,kernel="linear", ranges=list(cost=10^(-1:2), nu=seq(.1,1,.1))). the output of command is, expected, error , dispersion each combination of parameters, problem same error , dispersion each combination. this strange, considering exploring entire possible parameter space nu. what possibly going wrong ?
Read more