469,279 Members | 2,199 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,279 developers. It's quick & easy.

Greater than statement for 2 columns

hi guys,

i am doing an SQL question where the table is item and the two columns i have are reorderlevel and QOH

The question is List details for the items where the qty on hand exceeds the reorder level by 10 or more.

I have so far

select * from item
where QOH >
Mar 1 '08 #1
2 1232
qty on hand exceeds the reorder level by 10 or more

select * from item
where QOH >reorderlevel+10

hi guys,

i am doing an SQL question where the table is item and the two columns i have are reorderlevel and QOH

The question is List details for the items where the qty on hand exceeds the reorder level by 10 or more.

I have so far

select * from item
where QOH >
Mar 1 '08 #2
ck9663
2,878 Expert 2GB
qty on hand exceeds the reorder level by 10 or more

select * from item
where QOH >reorderlevel+10
If it's "10 or more", you might want to use greater or equal to operator, not just greater than.

-- CK
Mar 1 '08 #3

Post your reply

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

Similar topics

9 posts views Thread by Michael | last post: by
5 posts views Thread by Maurice Mertens | last post: by
2 posts views Thread by Geoffrey KRETZ | last post: by
reply views Thread by Michael Seele | last post: by
6 posts views Thread by Twobridge | last post: by
118 posts views Thread by Chuck Cheeze | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.