Record some SQL, afraid to forget

SELECT business_line,count(*fromgroup by Business_line;

This is displayed, showing how many xxx are in a certain item, note that group by

Select DISTINCT  from WHERE between ' 2017-06-13 16:00:00 '  and ' 2017-06-15 23:59:00 '

This is all the states that look at the existence of problems within this period of time.

SelectT_bug.id,t_bug.channel, Bug_type, 'desc', Step_to_string,model,version,t_device.platform,network fromT_bugJoinT_detail onT_bug.id=t_detail.bug_idJoinT_device onT_bug.id=t_device.bug_idwhereT_bug.id=t_bug.repeat_id andT_bug.idinch(  Selectbug_id fromT_levelwhere' Type '= 'P3') andT_bug.create_timebetween '2017-06-13 16:00:00'  and '2017-06-15 23:59:00'

This is very sexy, and there is no abbreviation for the table, relatively long.

It feels like SQL is a really, really profound thing to feel.

Log some SQL, afraid to forget