Search Results

Search found 2 results on 1 pages for 'kindson'.

Page 1/1 | 1 

• computed column with aggregate function

  - by Kindson

  I have seven columns in my table: hours, weight, status, total_hours, total_weight and percentage total_weight = weight where status = 'X' total_hours = hours where status = 'X' percentage = total_hours/sum(weight) sum(weight) is an aggregate function I would like to specify formula to generate the three computed columns. What do i do?

  Read the article

• My update query executes but doesn't update

  - by Kindson

  I have this update query. UPDATE production_shr_01 SET total_hours = hours, total_weight = weight, percentage = total_hours / 7893.3 WHERE (status = 'X') The query executes fine but the problem is that when this query executes, it doesn't update the percentage field. What might be the problem?

  Read the article

1