MySql视图从条件中删除子查询

SELECT actual, 
        curr, 
        CASE WHEN actual > anterior THEN 'raise' 
            WHEN actual < anterior THEN 'drop' ELSE 'nothing' 
        END as 'status' 
FROM ( 
        SELECT o.i_price as actual, o.i_currency as curr, 
                SELECT i.i_price 
                FROM Info i 
                WHERE i.i_article_id = 1 
                  AND i.i_insert < o.i_insert 
                ORDER BY i.i_insert DESC LIMIT 1
            ) AS anterior 
        FROM Info o 
        WHERE o.i_article_id = 1 
        ORDER BY o.i_insert 
        DESC LIMIT 1 ) as q

    create view my_q as 
    SELECT o.i_price as actual, o.i_currency as curr, 
                    SELECT i.i_price 
                    FROM Info i 
                    WHERE i.i_article_id = 1 
                      AND i.i_insert < o.i_insert 
                    ORDER BY i.i_insert DESC LIMIT 1
                ) AS anterior 
            FROM Info o 
            WHERE o.i_article_id = 1 
            ORDER BY o.i_insert 
            DESC LIMIT 1

    create  view my_top_view as

推荐文章

傲视众生的啤酒 · 让DIV的滚动条自动滚动到最底部 - 3种方法 - Newbie_小白 - 博客园

1 年前

追风的便当 · Java IO --ByteArrayOutputStream （六）*** - 江召伟 - 博客园

1 年前

酷酷的茶叶 · javascript - promise.all里异步比for of循环做异步操作时间更快吗？ - SegmentFault 思否

1 年前

玩篮球的手套 · 关于TabLayout+ViewPager无法显示标题问题_android tablayout+viewpager2 不显示标题_邓不了的博客-CSDN博客

1 年前

MySql视图从条件中删除子查询

2 个回答