Extraction in the table according to a recent type two each, thank you-CodePudding

Home > database > Extraction in the table according to a recent type two each, thank you

Extraction in the table according to a recent type two each, thank you

Time：03-14

Fields in table A dtype and cdate, how to obtain the data according to the cdate reverse, but 2 of each type of field dtype
Such as data in A

 
'a', '2016-3-1' 
'a', '2016-8-9' 
'a', '2015-7-3' 
'a', '2016-5-7' 
'b', '2013-3-4' 
'b', '2013-4-4' 
'b', '2013-3-4' 
'b', '2013-6-4' 
'b', '2013-5-4' 
'c', '2013-3-4' 
'c', '2013-6-4' 
'c', '2013-5-4'

I want to be:

 
'a', '2016-8-9' 
'a', '2015-7-3' 
'b', '2013-6-4' 
'b', '2013-5-4' 
'c', '2013-6-4' 
'c', '2013-5-4'

Page link：https//www.codepudding.com/database/104455.html

Prev:For help, pb calls dynamic library written in Delphi, the returned string garbled by parameters

Next:Why TurboC2.0 putimage function is unable to load the picture (black screen)

Tags：

MySQL

Links：
CodePudding