Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 25th, 2012  |  syntax: None  |  size: 0.52 KB  |  hits: 23  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. ij> DELETE
  2. FROM Liefert
  3. WHERE 1=ALL (
  4. SELECT COUNT(Farbe)
  5. FROM Liefert
  6. GROUP BY LiefNr
  7. );
  8. > > > > > > 0 rows inserted/updated/deleted
  9. WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
  10. ij> SELECT COUNT(Farbe)
  11. FROM Liefert
  12. GROUP BY LiefNr
  13. > > > ;
  14. 1          
  15. -----------
  16. 14        
  17. 2          
  18. 3          
  19. 9          
  20. 10        
  21. 3          
  22. 1          
  23. 7          
  24. 2          
  25. 1          
  26. 1          
  27. 2          
  28. 4          
  29. 2          
  30. 1          
  31. 3          
  32.  
  33. 16 rows selected
create a new version of this paste RAW Paste Data