how to validate table field value using sql?

See more:

SQL

Hi all,

I am trying to do the sql validation for one of my table field name.

for instance,

my sample table below,

id  productname  stock

1   test               10

2   testing            20

I want to validate, when the stock value comes in below 1 using select query or any other possible ways.

This is what I want.

So please guide me a solution for that.

Thanks in advance..