Sir I have this data
Group by hours
Or
First value of every hour
Please help
phphp
14
Junior Poster in Training
Recommended Answers
Jump to Postselect min(`Date`), `Qty` from `tablename` group by extract(hour from `Date`);
All 2 Replies
AndrisP
193
Posting Pro in Training
select min(`Date`), `Qty` from `tablename` group by extract(hour from `Date`);
AndrisP
193
Posting Pro in Training
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.