Your Ad Here

advanced code snippet search

Posted By

indianocean on 12/13/06


Tagged

Oracle


Versions (?)

Who likes this?

4 people have marked this snippet as a favorite

tylerhall
datorrey
depmed
ckayra


Faster "select from where NOT in"

 / Published in: SQL
 

Same result as: "select from where NOT in" but faster. The result is: all customers that don't have orders.

Expand | Embed | Plain Text 
  1. SELECT
  2.   Id
  3. FROM
  4.   customer c
  5. MINUS  
  6.   SELECT 
  7.     ID
  8.   FROM 
  9.     customer c,
  10.     ORDER o
  11.   WHERE 
  12.     c.id = o.c_id

Report this snippet  

You need to login to post a comment.