MYSQL Query using SUM -

-

how can make select 7500 or greater on_hand value column?

" list part number part descrtiption , onhand value each part on hand value @ least $7,500. assign on_hand_values computed column."

this have far, tried subquerys in statements cant figure out. 

select part_num, description, sum(on_hand * price) on_hand_value part sum(on_hand * price)'7500' group part_num, description;

part table 

part_num    description     on_hand     class   warehouse   price  at94       iron               50         hw         3       24.95 bv06       home gym           45         sg         2       794.95 cd52       microwave oven     32        ap          1       165.00 dl71       cordless drill     21        hw          3       129.95 dr93       gas range           8        ap          2       495.00 dw11       washer             12        ap          3       399.99 fd21       stand mixer        22        hw          3       159.95 kl62       dryer              12        ap          1       349.95 kt03       dishwasher          8        ap          3       595.00 kv29       treadmill           9        sg          2       1390.00

you can't use where, have use having aggregate functions:

select part_num, description, sum(on_hand * price) on_hand_value part group part_num, description; having sum(on_hand * price)'7500'

where evaluated before grouping , summing happens, having evaluates on result set, after records filtered , grouped


Comments

Post a Comment

Popular posts from this blog

javascript - Enclosure Memory Copies -

-
function myclass() { //lots , lots of vars , code here. this.bar = function() { //do numerous enclosed myclass vars } this.foo = function() { alert('hello'); //don't enclosed variables. } } each instance of myclass gets own copy of bar , foo, why prototyped methods use less memory. however, know more memory use of inner methods. it seems obvious me (1) below must true. agree? not distinct myclass instances have own distinct copies of bar, must have own distinct copies of myclass enclosure. (or else how bar method keep myclass variables straight on per instance basis?) now (2) question i'm after. since inner foo method doesn't use in myclass enclosure natural qustion is: javascript smart enough not keep myclass enclosure in memory use of foo? this depend entirely on implementation not language. naive implementations keep far more around others. answer true e.g. v8 (chrome's js engine) may not true spider...
Read more

php - Replacing tags in braces, even nested tags, with regex -

-
example preg_replace('/\{[a-za-z.,\(\)0-9]+\}/', 'replaced', 'lorem ipsum dolor sit {tag1({tag2()})}, consectetur adipiscing elit.'); the result: lorem ipsum dolor sit {tag1(replaced)}, consectetur adipiscing elit. question as can see "tag2" has been replaced, want replace "tag1" know how can this? (in cases might this: {tag1({tag2({tag3()})})}) , on.) btw using preg_replace_callback, easier show preg_replace here site can test code: http://www.spaweditor.com/scripts/regex/index.php you need add curly braces character set. here's pattern used: /\{[a-za-z.,\(\)\{\}0-9]+\}/ and here result: "lorem ipsum dolor sit replaced, consectetur adipiscing elit."
Read more