Sir I have this data

Untitledg_jygukg.png

Group by hours

Or

First value of every hour

Please help

select min(`Date`), `Qty` from `tablename` group by extract(hour from `Date`);

Sorry on MS SQL server use datepart instead of extract