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

推荐文章

微醺的匕首 · oracle 中模糊查询 like_oracle模糊查询like-CSDN博客

7 月前

鬼畜的雪糕 · Cron表达式范例：每隔5秒执行一次：*/5 * * * * ?_51CTO博客_cron表达式每5分钟执行一次

1 年前

高大的消防车 · Spring Data JPA 查询方法那些事_51CTO博客_spring-boot-starter-data-jpa

1 年前

幸福的红酒 · 【linux】使用systemctl start xxx启动自己的程序|开机启动|守护进程_51CTO博客_systemctl 设置开机启动

2 年前

有爱心的卡布奇诺 · Android Java 使用setOnSeekBarChangeListener或Button将两个SeekBar的数值相加。

2 年前

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

2 个回答