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

Untitled

By: a guest on Jul 14th, 2012  |  syntax: None  |  size: 0.63 KB  |  hits: 10  |  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. only select the row if the field value is unique
  2. SELECT * FROM tbl
  3. WHERE pk_artikel_id IN
  4.   (SELECT MIN(pk_artikel_id) AS id FROM tbl GROUP BY fk_artikel_bron)
  5.        
  6. SELECT *
  7. FROM  tbl
  8.   JOIN (
  9.     SELECT
  10.       fk_artikel_bron,
  11.       MIN(pk_artikel_id) AS id
  12.     FROM tbl
  13.     GROUP BY fk_artikel_bron) mins ON tbl.pk_artikel_id = mins.id
  14.        
  15. SELECT * from tbl t1
  16. LEFT JOIN tbl t2
  17.   ON t2.fk_artikel_bron = t1.fk_artikel_bron
  18.   AND t2.pk_artikel_id < t1.pk_artikel_id
  19. WHERE t2.pk_artikel_id IS NULL
  20.        
  21. select *
  22. ...
  23. group by pk_artikel_bron
  24.        
  25. select * from (
  26.     select *
  27.     ...
  28.     order by pk_artikel_id) x
  29. group by pk_artikel_bron