> For the complete documentation index, see [llms.txt](https://fivesobes.gitbook.io/nexorm/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://fivesobes.gitbook.io/nexorm/methods/finder-methods/usdcount.md).

# $count

Count the total number of records in the table based on the provided conditions.

| Query          | Parameter's                                                                                                                     |
| -------------- | ------------------------------------------------------------------------------------------------------------------------------- |
| **`$where`**   | <mark style="color:yellow;">**`<StaticProps>`**</mark>                                                                          |
| **`$options`** | <mark style="color:blue;">⇒</mark> [<mark style="color:green;">**`<FindOptions>`**</mark>](broken://pages/09lM7s4YrcyDgm9Uz8Ri) |

```typescript
var count = await Member.$count({
    $where: {
        userId: {
            $endsWith: '9'
        }
    },
    $options: {
        $logging(sql, benchmark) {
            console.log(sql,benchmark);  
        },
    }
});
```