Greater than statement for 2 columns

[napjohn8]

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 >

[SharpDeveloper]

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 >

[ck9663]

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