Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display customers having city other than gujarat and mp using not in

Posted By: Adelbert Fischer     Category: Oracle     Views: 1821

This article provides an example to display customers having city other than gujarat and mp using not in.

Code for Display customers having city other than gujarat and mp using not in in Oracle

Select cname from cust wherestatenotin (‘Gujarat’,’MP’);

Output:

CNAME     
-----------

Dhaval
Hardik
Jigar
  
Share: 

 
 
 


Adelbert Fischer
Adelbert Fischer author of Display customers having city other than gujarat and mp using not in 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!