SELECT CONVERT(finan_130630,DECIMAL) finan_130630, CONVERT(finan_121230,DECIMAL) finan_121230,CONVERT(finan_120630,DECIMAL) finan_120630,CONVERT(finan_111230,DECIMAL) finan_111230,CONVERT(finan_110630,DECIMAL) finan_110630,CONVERT(finan_101230,DECIMAL) finan_101230 from neeq_financial where id=1018;
select id,DATE_FORMAT(date,'%Y-%m-%d')from registered where DATE_FORMAT(date,'%Y-%m-%d') BETWEEN '2014-04-19' and '2014-04-22';
SELECT * from neeq_financial where financialtype=5810;
//总条数
SELECT count(id)*6 from neeq_financial;
SELECT finan_130630,finan_121230, IF(finan_130630<finan_121230,'yes ','no') from neeq_financial WHERE id=77;
SELECT finan_130630,finan_121230, IF(finan_130630<finan_121230,'yes ','no') from neeq_financial WHERE id=77 and (finan_130630-finan_121230)<0 ;
SELECT financialtype,shortname,CONVERT(finan_130630,DECIMAL) ,CONVERT(finan_121230,DECIMAL)from neeq_financial WHERE (financialtype=5801 and ((CONVERT(finan_130630,DECIMAL)-CONVERT(finan_121230,DECIMAL))/CONVERT(finan_121230,DECIMAL))=0.8)OR (financialtype=5801 and ((CONVERT(finan_130630,DECIMAL)-CONVERT(finan_121230,DECIMAL))/CONVERT(finan_121230,DECIMAL))=-0.8) or (financialtype=5802 and (finan_130630)=0) ;
select id,DATE_FORMAT(date,'%Y-%m-%d')from registered where DATE_FORMAT(date,'%Y-%m-%d') BETWEEN '2014-04-19' and '2014-04-22';
SELECT * from neeq_financial where financialtype=5810;
//总条数
SELECT count(id)*6 from neeq_financial;
SELECT finan_130630,finan_121230, IF(finan_130630<finan_121230,'yes ','no') from neeq_financial WHERE id=77;
SELECT finan_130630,finan_121230, IF(finan_130630<finan_121230,'yes ','no') from neeq_financial WHERE id=77 and (finan_130630-finan_121230)<0 ;
SELECT financialtype,shortname,CONVERT(finan_130630,DECIMAL) ,CONVERT(finan_121230,DECIMAL)from neeq_financial WHERE (financialtype=5801 and ((CONVERT(finan_130630,DECIMAL)-CONVERT(finan_121230,DECIMAL))/CONVERT(finan_121230,DECIMAL))=0.8)OR (financialtype=5801 and ((CONVERT(finan_130630,DECIMAL)-CONVERT(finan_121230,DECIMAL))/CONVERT(finan_121230,DECIMAL))=-0.8) or (financialtype=5802 and (finan_130630)=0) ;