How to use SQL to read the maximum Max and the second largest max for a secondary table ....

SELECT' Main Table '. ID, ' Main Table '. Title, ' Auxiliary table '.*  fromTableB as' auxiliary watches 'INNER JOINTableA as' Main Table ' on' Main Table '. ID=' auxiliary table '. firm_idWHERE#子查询判断该行是否需要取出, the maximum count of one bar is 0 times the count of 1, and the remainder does not satisfy the condition so it is not read (SELECT     COUNT(' Auxiliary table 2 '. Create_time) fromTableB as' Auxiliary table 2 'WHERE' Main Table '. ID=' auxiliary table 2 '. firm_id and' Auxiliary table 2 '. Create_time>' Auxiliary table '. ' Create_time ')< 2 ORDER  by' Main Table '. ID, ' auxiliary table '. Create_timeDESC 

Take the largest one can use Max, take the second largest do not need to use the Max function ....

How to use SQL to read the maximum Max and the second largest max for a secondary table ....