Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display 2 items having lowest current stock

Posted By: Imogen Brown     Category: Oracle     Views: 3542

This article provides an example to display 2 items having lowest current stock.

Code for Display 2 items having lowest current stock in Oracle

Select itemname from (select itemname from item orderby qty_hand) where rownum <= 2;

Output:

ITEMNAME
---------

Floppy
Mouse
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Display 2 items having lowest current stock Or get search suggestion and latest updates.

Imogen Brown
Imogen Brown author of Display 2 items having lowest current stock 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!