Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


MySQL help needed
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

MySQL help needed

So, I have nasty query on my hands:

https://pastebin.com/ehWLMF2t

The problem is, when there is 2 servers in same location and with same priority and status - my result set duplicates.

Question: how to select only 1 server from servers where server priority and status is equal?

I've tried DISTINCT'ing:

<...>SELECT DISTINCT MIN(priority) FROM servers WHERE status = 1

No luck.

Comments

Sign In or Register to comment.