Help optimize sql query?

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

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 – msony Jun 10 '10 at 4:25 misunderstood the question. Editing answer. – nathan gonzalez Jun 10 '10 at 4:27.

Swear I didn't copy, though the formatting similarities are uncanny... – nathan gonzalez Jun 10 '10 at 4:36.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.