Hi everyone I am using Syabse databse.
I have designed a table of following format

quote:
--------------------------------------------------------------------------------
DateTime feed_name msg_rate
--------------------------------------------------------------------------------



I want to write a query for calculating Busy minute of day,
Busy minute mean when for particular one min msg_rate has to be maximum and generally DateTime field is stored at the interval of 30 sec.I have to acess table in sequential order and for a particular day i have to calculate busy day???


Can anyine tell me how to do this??????
Database used is Sybase