self join and order by

  • 0

    I wonder if there is a simple and generic solution using variable to solve problems like more than n consecutive rows.

    select distinct,, a.people
    from stadium a, stadium b, stadium c
      where (( and or ( and or ( and and
            (a.people>=100 and b.people>=100 and c.people>=100)
    order by

Log in to reply

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.