mysql repeated query

Question

I don't want it to repeat in the query you see in the example, I want it to show only one

SELECT bulten.id,group_concat(spor.sonuc)as result,count(spor.sonuc)as total FROM bulten 
INNER JOIN spor on bulten.ms1=spor.ms1 AND bulten.lig=spor.lig
group by bulten.id

http://sqlfiddle.com/#!9/0d277a/1

bulten table There are 3 units of 1.10 and GER,repeats 3 times, I want it to repeat once — ThePro
– ThePro, Commented Jan 27, 2022 at 23:21
You have inserted this combination 3 times into the table "bulten", review your fiddle... — Honk der Hase
– Honk der Hase, Commented Jan 27, 2022 at 23:24
Your actual issue is, that your database is not normalized and you're using the wrong fields for referencing tables. If your database is in 3NF and you follow its rules, your problem will dissolve automatically — Honk der Hase
– Honk der Hase, Commented Jan 27, 2022 at 23:42

nbk · Accepted Answer · 2022-01-27 23:28:03Z

1

You need to groupp the bulten table before joining

SELECT bulten.id,group_concat(spor.sonuc)as result,count(spor.sonuc)as total 
FROM (SELECT  MIN(id) as id ,ms1, lig  FROM bulten GROUP BY ms1, lig) as bulten
INNER JOIN spor on bulten.ms1=spor.ms1 AND bulten.lig=spor.lig
group by bulten.id

see http://sqlfiddle.com/#!9/0d277a/5

answered Jan 27, 2022 at 23:28

nbk

49.6k8 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

ThePro Over a year ago

In addition, can we calculate how many matches have been won and how many matches have been lost?

ThePro Over a year ago

can we do 1 win 1 los 50%

nbk Over a year ago

yes of course if it doesn't fit in a1 query make a subquery and join it

nbk Over a year ago

you need first to have a chek function if the result is a win or a draw, i will take later a look if i find a quick solutin

nbk Over a year ago

You can do something like this to get win and draw, if you need cpunt add it to the subquery so that you have all the number to get your procentage see sqlfiddle.com/#!9/0d277a/34 but next time ask a new question

|

Collectives™ on Stack Overflow

mysql repeated query

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related