I recently blogged about this exact topic, not sure if it works in Sybase though, here's the solution

declare @interval int
set @interval = 5
select datepart(hh, DateTimeColumn)
, datepart(mi, DateTimeColumn)/@interval*@interval
, count(*)
from thetable
group by datepart(hh, DateTimeColumn)
, datepart(mi, DateTimeColumn)/@interval*@interval

and more details http://ebersys.blogspot.com/2010/12/sql-group-datetime-by-arbitrary-time.html

• How to Get The Count or The Number Of Rows In A Result Set In PHP using ODBC Connection?

  While I build a web page in My PHP web application, My Connection works ok but When I want to get the count of rows of the SELECT Statement I used in my query, It gives me -1 !! although my result s…

• How can I count unique pairs of values in SQL?

  With the following sql statement I can get all unique values with their counts for a given column: select column, count(column) as count from table group by column order by count desc; …

• Write a SQL query that retrieves all distinct rows having the same value in a column where count of these rows is larger than 1

  Basically I need to find all the ids with more than 1 name so the output should be (2,a)(2,b)(4,a)(4,b)(4,c) id name 1 a 2 a 2 b 3 c 3 c 4 a 4 b 4 c I got a query working sel…

• Count Number of Rows in a SQLite Database

  I'm trying the following code to count the number of rows in my SQLite database table, but it throws an exception. Is these a simpler way to do this? - (void) countRecords { int rows = 0; @tr…

• How can I make the Count function return 0?

  I am trying to create a series of queries in Access that count the number of clients of each ethnicity in each of 77 counties. Here is SQL code for one of my queries that I'm trying to do this fo…

• SQL Query to count the number of each element in an object

  I have a database table like this: Room Name || Animal Room1 || Cat Room1 || Dog Room1 || Dog Room2 || Cat Room2 || Cat Room2 || Dog Room2 || Dog I want to read this t…

• How can an get count of the unique lengths of a string in database rows?

  I am using Oracle and I have a table with 1000 rows. There is a last name field and I want to know the lengths of the name field but I don't want it for every row. I want a count of the various l…

• SQL: How to get the count of each distinct value in a column?

  I have a SQL table called "posts" that looks like this: id | category ----------------------- 1 | 3 2 | 1 3 | 4 4 | 2 5 | 1 6 | 1 7 | 2 Each category number corresponds to a category. How wou…

• How do I count the number of deleted rows in a MYSQL query?

  I'm trying to find out whether a delete query executed properly. I know how many rows its supposed to delete, and I'd like to check that the number that were deleted, matches what's expected, from w…

• How do I select row based on the number of times it appears in the table?

  I have my table: call it tblA THis table has three rows, id , sub-id , and visibility sub-id is the primary key (it defines taxonomies for id ). I'm trying to build a query that selects every id…