Hello
I've got a table called invoice with a field supplier and another one invoice_category among others.
How can I retrieve all the suppliers that have more than two categories in the invoice table.
I tried
but it didn't work.
Any ideas?
I've got a table called invoice with a field supplier and another one invoice_category among others.
How can I retrieve all the suppliers that have more than two categories in the invoice table.
I tried
Code:
select count(*) from (select distinct invoice_category from invoice)
Any ideas?