New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

这个 SQL 如何优化？ #3

Open

diguage opened this issue Sep 25, 2020 · 0 comments

Owner

diguage commented Sep 25, 2020

select id,
       uuid,
       billId,
       -- 各种字段
from bill_rule
where uuid= '1'
  and billId = (select billId
                from bill_rule
                where uuid= '1'
                  and billStatus = 1
                order by billDate desc
                limit 0,1);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment