Skip to content

这个 SQL 如何优化? #3

@diguage

Description

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions