Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • blak
    blak

    @blak-xvIZ0J • Mar 20, 2011

    select city_name,min(population) pop
    from
    (
    select city_name, population from table1
    union
    select city_name, population from table2
    union
    select city_name, population from table3
    union
    select city_name, population from table4
    )
    group by city_name
    order by pop;

    0
  • ISHAN TOPRE
    ISHAN TOPRE

    @ishan-nohePN • Mar 20, 2011

    select city_name,
    from table1, table2, table3, table4,
    where population<= P1, P2, P3, P4.

    0