Simulating window functions in Firebird -

-

is there can me query.

here table.

enter image description here

when run query. result illustrated below.

enter image description here

total_bins_per_site field sum of bin count group site. here query

  select     x.site,     x.status,     x.total_bins_per_bin,     (select sum(bin_count) ts_bins_per_site id = x.id) total_bins_per_site     (select id, sum(bin_count) total_bins_per_bin, site site, status status     ts_bins_per_site     status = 'p'     , id = (        select a.id        ts_rec_data        join ts_main_rec b        on a.rec_id = b.id        b.lot_id = 'qyyzca004k'        , b.tester_id = 'ltxmxspc035'        , a.datemodified = '5/30/2014 10:01:05')        group site, status, id ) x

it working problem total_bins_per_site sum bin count, expected sum bin_count group site. example site 1, total_bins_per_site suppose 5 because bin_count 4 + bin_count 1 in site 1. know query in 5th line missing "group site", when added 5th line, error says "multiple rows in singleton select". can me out of here? much!

the problem subquery in select has condition where id = x.id, instead should use where site = x.site (or maybe where site = x.site , id = x.id) items site in summation.

in upcoming firebird 3 can simplified using window functions, example using 

sum(total_bins_per_bin) on (group x.site) total_bins_per_site

instead of subquery in select.


Comments

Post a Comment

Popular posts from this blog

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more