help optimize sql query

Posted by msony on Stack Overflow See other posts from Stack Overflow or by msony
Published on 2010-06-10T04:20:21Z Indexed on 2010/06/10 4:32 UTC
Read the original article Hit count: 293

Filed under:
|
|
|
|

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

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server