I am New in Mysql.I have to find six month interval.Assume latest date is 2022-03-23 if date is between jan to jun then print:

else latest date 2022-09-19 is july to december.

may be last date value 30,31,23 accordding to my db.

here is my data.sql file

i am getting this output.

my query is:

SELECT price_date FROM boot.marketprice where f_id=1 and i_id=2 group by year(price_date),month(price_date)in(6,12);

I need this output

CodePudding user response：

I want two intervals of a year.

SELECT price_date FROM boot.marketprice where f_id=1 and i_id=2 group by year(price_date),month(price_date)=6;

if you want every quarter data

SELECT price_date FROM boot.marketprice where f_id=1 and i_id=2 group by year(price_date),QUARTER(price_date);

if you want every week's data

SELECT price_date FROM boot.marketprice where f_id=1 and i_id=2 group by year(price_date),week(price_date);