SQL Group same ID with another condition

Question

I believe it’s a little specific question, because I haven’t found anything related yet.

I have a table called contas_produtos, which is a relationship Nxn between the tables contas and the table produtos.

The table has the following columns:

ID (PK)
conta_id (FK)
produto_id (FK)
precoFinal (float)

Well, this one precoFinal indicates the final value of a given product, which can be changed by the application, ie two products can have the same id, but with different values of precoFinal.

What I wish to do is to be able to group the same products id, but with equal final prices, and separate these products from those that have even id but different final prices.

I know I can’t just group by precoFinal, because it would take products with different prices.

What I’ve done so far is group by id, but it does not serve me, therefore it does not compensate nor I put my SQL here.

A lot of text, I know, but I think it would be easier to explain like this.
Thank you

Answer 1

See if it solves

SELECT conta_id, 
       produto_id, 
       precofinal 
FROM   ((produtos 
         INNER JOIN contas_produtos 
                 ON id = conta_id) 
        INNER JOIN produtos 
                ON produto_id = produto_id ) 
GROUP  BY id, 
          precofinal 

Answer 2

Well, I’m sorry, I managed to settle just by using group by with more than one column, as follows:

SELECT Count(*) AS quantidade, 
       conta_id, 
       produto_id, 
       precofinal 
FROM   conta_produtos 
GROUP  BY produto_id, 
          precofinal