· 1 min read

Simple SQL for Counting New Signups

Here is a little snippet that will return new signups (or new records) for today

select id, email, created_at::date date from signups
where email not in (select distinct email from signups where created_at < current_date)

Comments

Leave a comment