Home » RDBMS Server » Server Administration » One step more
One step more [message #373513] Fri, 20 April 2001 07:04
Karri Lahtela
Messages: 16
Registered: November 2000
Junior Member
Hi

Now I need to modify table so that there is only one row for PART_NO. Now it looks like:
PART_NO QTY
------------------------- -----------
490-1230-6 -32.815
490-1230-6 50.195
490-1230-6 -7.185
623-0174-0/0,3 -134.45
623-0174-0/0,3 -3.6

How can I do that kind of where clause that it calculates all lines. Not only one part_no.
Is it possible or not?

BR:Karri
Previous Topic: Urgent! How can I create view witch do calculates a sum
Next Topic: how to display the initials ?
Goto Forum:
  


Current Time: Mon Dec 23 09:39:03 CST 2024