Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Sub QueryRSS Feeds

Example of sub query to display items having item price less than Keyboard

Posted By: Hollie Hughes     Category: Oracle     Views: 3050

This article provides an example to example of sub query to display items having item price less than Keyboard.

Code for Example of sub query to display items having item price less than Keyboard in Oracle

Select itemname from item where itemprice < (select itemprice from item where itemname like'Keyboard');

Output:

ITEMNAME
---------
Floppy Cds Mouse
  
Share: 



Hollie Hughes
Hollie Hughes author of Example of sub query to display items having item price less than Keyboard is from London, United Kingdom.
 
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!