1

Topic: Help with advanced query.

Good afternoon.
It is necessary to make advanced query, tried  the task, came to that that I have a table with 4 columns.
id_1, id_2, counter_1, counter_2
I need to receive steams id_1+id_2 with maximum counter_1/counter_2 provided that counter 1 can be 0.
I will be glad to any help, including messages in Google, only with the help what to search)

2

Re: Help with advanced query.

How much I understood the task:

SELECT id_1, id_2, MAX (counter_1/counter_2)
FROM mytable
WHERE counter_2 <> 0
GROUP BY id_1, id_2

3

Re: Help with advanced query.

miksoft;
Thanks big, I will try.