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