sql server - sql is not returning correct count -

-

i have sql table hr_registrantcategories this:

registrantid    categoryid 1   47 4   276 4   275 4   278 4   274 4   277 16276   276 16276   275 16276   278 16295   276 16295   275 16295   278 16295   274 16295   277 16292   276 16292   275 16292   278 16292   274 16292   277 16293   276 16293   275 16293   278 16293   274 16293   277 16294   276 16294   275 16294   278 16294   274 16294   277 16303   276 16303   275 16303   278 16303   274 16303   277 16302   276 16302   275 16302   278 16302   274 16302   277 16303   276 16303   275 16303   278 16303   274 16303   277 16304   276 16304   275 16304   278 16304   274 16304   277 26  276 26  275 26  278 26  274 26  277 16305   276 16305   275 16305   278 16305   274 16305   277 29  276 29  275 29  278 29  274 29  277 16306   276 16306   275 16306   278 16306   274 16306   277 16306   276 16306   275 16306   278 16306   274 16306   277 16307   276 16307   275 16307   278 16307   274 16307   277 16307   276 16307   275 16307   278 16307   274 16307   277

and table hr_categories this:

categoryid 1 2 3 4 5 6 ... .. .. 700

but returning same count in result when use following query

select  count(rc.registrantid)             dbo.hr_registrants r inner join dbo.hr_registrantcategories rc on r.registrantid = rc.registrantid             r.deleted = 0              , rc.categoryid in (select categoryid dbo.hr_categories)               select c.categoryid,             (            select  count(distinct rc.registrantid)             dbo.hr_registrants r inner join dbo.hr_registrantcategories rc on r.registrantid = rc.registrantid             r.deleted = 0              , rc.categoryid in (select categoryid dbo.hr_categories c1 c1.deleted = 0)           )as registrantscount         dbo.hr_categories c

result is:

categoryid  registrantscount 1   13 2   13 3   13 4   13 5   13 6   13 7   13 8   13

the inner query not correlated withe outer one, returns same value each line.

select c.categoryid,         (        select  count(distinct rc.registrantid)         dbo.hr_registrants r inner join dbo.hr_registrantcategories rc on r.registrantid = rc.registrantid         r.deleted = 0          , rc.categoryid in (select categoryid dbo.hr_categories c1 c1.deleted = 0)          , rc.categoryid = c.categoryid -- correlate outer query  )as registrantscount     dbo.hr_categories c

Comments

Post a Comment

Popular posts from this blog

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more