472,145 Members | 1,605 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Subtracting from lowest value

I have a table that has SeqID, BoxID, Sku, Qty. I have multiple boxes of the same item and want to subtract from the Qty with the lowest SeqID only. What are some examples of doing this?
Feb 20 '09 #1
1 1571
2,878 Expert 2GB
Use MIN() to find which one has the lowest value. Then subtract it from there.

Feb 20 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

31 posts views Thread by Spiro Trikaliotis | last post: by
5 posts views Thread by jayipee | last post: by
17 posts views Thread by rhitz1218 | last post: by
4 posts views Thread by tomek milewski | last post: by
54 posts views Thread by namcintosh | last post: by
30 posts views Thread by =?Utf-8?B?VGhvbWFzVDIy?= | last post: by
6 posts views Thread by Patrick Fisher | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.