CODEWITHSUNDEEP
sql-server
fabis
fabis

Reputation: 13

Show repeating records as a single record

I combine 3 tables. But there are lines that repeat in single tablature. I want to show them as a single line.

SELECT
  COUNT(gelenhaberlerimage.HaberKodu) AS Expr1,
  gelenhaberaciklama.id,
  gelenhaberaciklama.HaberKodu,
  gelenhaberler.id AS Expr2,
  gelenhaberler.HaberKodu AS Expr3,
  gelenhaberler.Sehir,
  gelenhaberler.title,
  gelenhaberlerimage.id AS Expr4,
  gelenhaberlerimage.HaberKodu AS Expr5,
  gelenhaberlerimage.BuyukResim
FROM
  gelenhaberaciklama 
INNER JOIN
  gelenhaberler ON gelenhaberaciklama.HaberKodu = gelenhaberler.HaberKodu 
INNER JOIN
  gelenhaberlerimage ON gelenhaberaciklama.HaberKodu = gelenhaberlerimage.HaberKodu 
GROUP BY
  gelenhaberaciklama.id,
  gelenhaberaciklama.HaberKodu,
  gelenhaberler.id,
  gelenhaberler.HaberKodu,
  gelenhaberler.Sehir,
  gelenhaberler.title,
  gelenhaberlerimage.id,
  gelenhaberlerimage.HaberKodu,
  gelenhaberlerimage.BuyukResim 
HAVING
  (COUNT(gelenhaberlerimage.HaberKodu) > 1)

Upvotes: 0

Views: 85

Answers (1)

Tabby
Tabby

Reputation: 101

Use Distinct with Select statement to avoid repeating records. Here is a link which might help SQL SELECT DISTINCT Statement

Upvotes: 1

Related Questions