I ha
Code: Select all
ID SessionID Date userIP jobID
1 1a4012cae0564bd1fd1ba28a59617cc1 1148567929 81.153.130.30 1
2 1a4012cae0564bd1fd1ba28a59617cc1 1148567954 81.153.130.30 1
3 1a4012cae0564bd1fd1ba28a59617cc1 1148568004 81.153.130.30 1
4 650feced17da4214d677522f00b447a8 1148568064 54.121.192.56 1
5 1a4012cae0564bd1fd1ba28a59617cc1 1148568316 81.153.130.30 2
6 1a4012cae0564bd1fd1ba28a59617cc1 1148568508 81.153.130.30 1If so, roughly what would the query look like.
The result for the above sample data should be
Job 1 = 2 unique hits
Job 2 = 1 unique hit
Thanks