Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display items having item price between 100 to 500 using select query

Posted By: Alice Miller     Category: Oracle     Views: 5949

This article provides an example to display items having item price between 100 to 500 using select query.

Code for Display items having item price between 100 to 500 using select query in Oracle

select * from item where itemprice >200 and itemprice <500;

Output:

ITEMNO    ITEMNAME    ITEMPRICE        QTY_HAND        COLOR
-------   ---------   ----------       ---------       ------
I0001 Pendrive 450 400 Black I0004 Mouse 400 75 White
  
Share: 



Alice Miller
Alice Miller author of Display items having item price between 100 to 500 using select query is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!