Member Avatar for sendilkumar06

I need to SQL Query to get the value from database for every half hour or 15 minutes.
E.g There are data updating in a table for every 1minute. I need to get the avearge of every 15minutes and give as single data.

Kindly help me on this query

  • 2 Contributors
  • 1 Reply
  • 72 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by pty
Member Avatar for pty

I need to SQL Query to get the value from database for every half hour or 15 minutes.
E.g There are data updating in a table for every 1minute. I need to get the avearge of every 15minutes and give as single data.

Kindly help me on this query

Create a job, insert what you get from your query into another table.

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.