sql server - Why is this query returning unwanted results? -

sql server - Why is this query returning unwanted results? -

Good morning,

I have a problem with this question:

 < code> Pergunta, North, COUNT (*) aS include selection as the IP.nome Qtd P.txt_nome from tb_resposta_formulario RF insider formularios F.id_formulario = RF.id_formulario insider F which P.id_pergunta on tb_pergunta P = including RF.id_pergunta join interiors are Tb_resposta_formulario_combo RFC on RFC.id_resposta_formulario = RF.id_resposta_formulario INP INP on Aipikaidi_aitem_prgun = Arfsikaidi_aitem_prgun where Arfkaid _ Formulaaru = 2 Group Piktiktiktikti.an.am.amk, Aipiknam

The actual results of this query:

| Pergunta | Resposta | Qtd |
Produto | Combo 1 mb | 3 |
Produto | Combo 2 MB | 5 |
Produto | Combo 4MB | 1 |
Produto | Combo 6MB | 1 |
Produto | Combo 8MB | 4 |
Régio | MG | 3 |
RegioO | Pr | 2 |
Régio | RJ | 3 |
Régio | SC | 1 |
Régio | SP | 5 |

These are the results I was hoping for:

| Produto | Região | Qtd |
Combo 1 mb | MG | 3 |
Combo 2 MB | SP 5 |
Combo 4 MB | Scheduled Caste | 1 |
Combo 6 MB | RJ | 1 |
Combo 8 MB | Pr | 2 |

I am using pivot and UNPIVOT operators, but the result is not satisfactory.

Has anyone had to face this situation beforehand?

li>

Att, Pelegrini

text after

"clear" answer: Because the query is wrong we really do not know anything about the table structure and what you are trying to achieve.

At least one very basic problem in your query: You are expecting the column | Produto | Northeast Qtd | in your answer, even though the question is clearly selected columns Pergunta , Reposta and Qtd , Which you are getting results with matching

  How well are you familiar with SQL? To read an introductory text may be worth it I was suggested as a good introduction (using Oracle, but the principles are the same)








03:22

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment








Popular Posts




linux - C++: undefined reference to `sd_notify' -



    i'm new c++. problem have process creates lot of processes, want identify(get pid) of 1 of children. looping through children take lot of resources(don't ask why). i'm trying pid of process (somehow) identifying if uses sd_notify  , pid(i don't if possible). i'm using ubuntu 14.04 , created little test program:   #include <systemd/sd-daemon.h> #include <stdio.h>  int main() {   int a;   = sd_notify(0, "ready=1");   printf("%d -> \n", a);   fflush(stdout); }   but gives me error saying undefined reference 'sd_notify' .   p.s  found sd_notify  systemd systems. equivalent of in upstart systems? or how can make sure process i'm searching doen't use function? or possible log messages send processes using sd_notify ?          try installing libsystemd-daemon-devel  , compile using   g++ -o sig sig.cpp -lsystemd-daemon       











server - Httpd(apache) is not starting on fedora 23 -



    i tried install nginx , didn't work. after tried install , configure apache(httpd) server on fedora23 dist. server doesn't want start namely doesn't work , returns errors , when try start it: sudo systemctl start httpd  job httpd.service failed because control process exited error code. see "systemctl status httpd.service" , "journalctl -xe" details.   , after saw logs in journalctl -xe . shows this:       jun 28 11:26:49 cyber audit[15981]: cred_refr pid=15981 uid=0 auid=1000 ses=1 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=pam:s jun 28 11:26:49 cyber sudo[15981]: pam_systemd(sudo:session): cannot create session: running in session jun 28 11:26:49 cyber kernel: audit: type=1105 audit(1467095209.363:842): pid=15981 uid=0 auid=1000 ses=1 subj=unconfined_u:unconfined_r:unconfined_t: jun 28 11:26:49 cyber sudo[15981]: pam_unix(sudo:session): session opened user root (uid=0) jun 28 11:26:49 cyber audit[15981]: user_start pid=1...






ios - Swift: Realm accessed from incorrect thread -



    i pass previous view controller. want show data save in other view controller.       override func prepareforsegue(segue: uistoryboardsegue, sender: anyobject?) {     if (segue.identifier == "beacons") {           let nav = segue.destinationviewcontroller as! uinavigationcontroller         let svc = nav.topviewcontroller as! beaconcharacteristicviewcontroller         svc.selectedlist = sender as! beacons       }   and         var selectedlist : beacons!   and code error reason.   i don't use primary key or have use it.       func loadproperties(){        let beacons = selectedlist        let priority = dispatch_queue_priority_default        dispatch_async(dispatch_get_global_queue(priority, 0)) {          do{             try uirealm.write({ () -> void in                  beacons.uuid = self.beaconuuid.text!                 print("uuid = \(beacons.uuid)")                  beacons.major = self.beaconmajor.text!                 print("uuid = \(beacons.u...








Powered by Blogger