Question: I am setting up a Serverless application for a system and I am wondering the following:

Say that my table handle Companies. Each Company can have Invoices. Each company has roughly 6-8000 Invoices. Say that I have 14 Companies, that results in roughly 112 000 items in my table.

Is it "okay" to handle it this way? I will only pay for each Get request I do, and I can query a lot of items into the same get request.

* I will not fetch every single item each time I write or get items.

So, is there a recommendation for how many items I should max have in a table? I could bake some items together, but I mainly want a general recommendation.

Answer: 
ok , here is how you can do it :

```
select * from (
   select * , count(*) over (partition by id) cn
   from tablename
) t
where cn = 1 

```
Try this:

```
SELECT *
FROM [Input]
WHERE ID IN (
    SELECT ID FROM [Input] GROUP BY ID HAVING COUNT(ID) = 1
)

```