Member Avatar for phphp

Sir I have this data

Untitledg_jygukg.png

Group by hours

Or

First value of every hour

Please help

  • 2 Contributors
  • 2 Replies
  • 288 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by AndrisP
Member Avatar for AndrisP 
select min(`Date`), `Qty` from `tablename` group by extract(hour from `Date`);
Member Avatar for AndrisP

Sorry on MS SQL server use datepart instead of extract

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.