i have one table,which maintain daily transactions for each minitute,but i would like to know per day for each 15 minutes interval how many rows are entering into that table

If you want to know AVERAGE per 15 minute period:

select count(1)/96 from table1 where trans_dt = '2005-06-09'

24 hours * 4 15 minute periods per hour = 96

If you actually want to know how many records per each individual 15 minute period, you'll have to run 96 queries.

select count(1) from table1 where trans_dt >= '2005-06-09 12:00' and trans_dt < 
'2005-06-09 12:16'

select count(1) from table1 where trans_dt >= '2005-06-09 12:16' and trans_dt < '2005-06-09 12:31'

select count(1) from table1 where trans_dt >= '2005-06-09 12:31' and trans_dt < '2005-06-09 12:46'

...and so on
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.