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: 4063

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!