Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display invoices having items greater than or equal to 3

Posted By: Abelerd Fischer     Category: Oracle     Views: 1543

This article provides an example to Display invoices having items greater than or equal to 3.

Code for Display invoices having items greater than or equal to 3 in Oracle

selectdistinct invno from invitem where qty >= 3;

Output:

IN001
IN005
IN003
IN004
IN002
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Display invoices having items greater than or equal to 3 Or get search suggestion and latest updates.

Abelerd Fischer
Abelerd Fischer author of Display invoices having items greater than or equal to 3 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!