I wish to find the total number of distinct records in a table. 
I have a table with the following columns

```
id, name, product, rating, manufacturer price

```

This has around 128 rows with some duplicates based on different column names.

I only want to select distinct rows:

```
select distinct name, product, rating, maufacturer, price from table

```

This returns 47 rows

For pagination purposes, I need to find the total number of distinct records, so I have another satatement:

```
select distinct count(name), product, rating, maufacturer, price from table

```

But this returns 128 instead of 47. 

How can I get the total number of distinct rows? Any help will be much appreciated. Thanks