Hi, I woud like to ask for help with sql select. I have table -> visitor, arrival, departure. (Time is in timestamp in sec. from 1970) I need select top of concurrently present visitors, between 00.00 and 29.59. So my boss want know when was shop most full and how many wisitors was there. May be other thing which would by nice is select top of concurrently present visitors every 5 minutes like format 00.05 4, 00.10 5, 00.15 8 ,00.20 6 ... 23.55 7. Thanks for any idea Beld
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php