How to use between more than 3 times in a single query?
866768Jul 6 2011 — edited Jul 7 2011is there any other query to run this query??
SELECT IDSITE,IDVISIT,trim(initcap(page_path)),KEYWORDS,LOCATION_IP,REFERER_NAME,REFERER_URL,VISIT_ACTION_TIME,count(DISTINCT location_ip) from web_stats where idvisit between '441' and '456' and where idsite='1' and visit_action_time between '4-jun-11' and '6-jun-11' group by trim(initcap(page_path)) and order by visitid;
Edited by: 863765 on Jul 7, 2011 4:21 AM