mysql随便记些

SQL查询案例与解析

最新推荐文章于 2024-09-09 17:04:52 发布

原创最新推荐文章于 2024-09-09 17:04:52 发布 · 715 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

7 篇文章

订阅专栏

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) ;