By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,610 Members | 1,923 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,610 IT Pros & Developers. It's quick & easy.

Greater than statement for 2 columns

P: 2
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
Share this Question
Share on Google+
2 Replies


P: 12
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
Expert 2.5K+
P: 2,878
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.