help optimize sql query

Question

I have tracking table tbl_track with id, session_id, created_date fields

I need count unique session_id for one day

here what i got:

select count(0) 
from (
       select distinct session_id
       from tbl_track 
       where created_date between getdate()-1 and getdate()
       group by session_id
)tbl

im feeling that it could be better solution for it

nathan gonzalez · Accepted Answer · 2010-06-10 04:29:52Z

5

select count(distinct session_id)
from tbl_track
where created_date between getdate()-1 and getdate()

edited Jun 10, 2010 at 4:29

answered Jun 10, 2010 at 4:23

nathan gonzalez

12k4 gold badges43 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sasha Over a year ago

but here i will get many rows (count for each session_id), but what i need is one row with count of all unique session_id

Gabe · Accepted Answer · 2010-06-10 04:27:44Z

5

Why not just do exactly what you ask for?

   select count(distinct session_id)
   from tbl_track  
   where created_date between getdate()-1 and getdate()

answered Jun 10, 2010 at 4:27

Gabe

87.1k13 gold badges144 silver badges238 bronze badges

Collectives™ on Stack Overflow

help optimize sql query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related