How to Select in My Query?

Question

How to write select command for starting amount to End amount.

For Example: Mobile Shop Select Mobile Company Name: Samsung and From amount=1500 to End amount=15000. i want show this two different Mobile Models.


Pls Send With Example.




Thanks&Regs


Magesh.A