mysql_real_escape_string / Говнокод #3691 Ссылка на оригинал

0

  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
Гавнокод --

SELECT * FROM  Table1
WHERE [Id] not in 
		(
		SELECT min([Id]) FROM Table1
		WHERE [Code] in 
				(
				SELECT [Code] FROM Table1
				GROUP BY [Code]									HAVING count([Code]) > 1
				)
					GROUP BY [Code]
		)
	and [Id] in 
		(
				SELECT [Id] FROM Table1
				WHERE [Code] in (
						SELECT [Code] FROM Table1
						GROUP BY [Code]
						HAVING count([Code]) > 1
						)
		)


Нормальний варіант --

SELECT * FROM Table1 AS a
WHERE [Id] not in 
		(
			SELECT min([Id]) FROM a_ListParam
			WHERE a_ListParam.[Code] = a.[Code]
		)

Запостил: O_O O_O, (Updated )

Комментарии (5) RSS

Добавить комментарий

Переведи на "PHP", guest!

    А не использовать ли нам bbcode?

    ↑
    8
    ↓