SELECT Name,Date,`T-2`,`T-1`,DiffSELECT T.Name ,T.Date,T.`T-1`,TT.`T-2`,TT.`T-2` - T.Date, cnt AS 'T-1' from Acct where date = curdate() - 1 )T(select Name, Date, cnt AS 'T-Out :Mills 2
示例数据: ID `Image Tag` `CD3 Global Den… `CD8 Global Den… `CD20 Global De… `CD3 Tumour Den… `CD8 TumourID `Image Tag` `CD3 Global Den… `CD8 Global Den… `CD20 Global De… `CD3 Tumour Den… `CD8 Tumour Den