How to get non-repeating combinations of two or more fields and the number of such combinations?

Question

SQL

Hello.
Given: view table

field1	field2	fieldN
a	a	...
a	b	...
b	a	...
a	b	...
a	a	...
b	b	...

Please tell me how to get non-repeating combinations of two fields and the number of such combinations. Those. the result should look like this

field1	field2	count
a	a	2
a	b	2
b	a	one
b	b	one

Thank you.

Answer 1

group by

select fld1, fld2, count(*) from tblname group_by fld1, fld2