3,494
社区成员




SQL> select * from ta;
ID COMPANY_NAME VALUE
----------- ---------------------------------------- ----------------
1001 microsoft 85000000000
1002 apple 70000000000
1003 google 75000000000
1004 lenovo 5000000000
1005 taobao 100000000000
SQL> select * from tb;
ID COMPANY_NAME NUM_OF_EMP
------------ ---------------------------------------- -----------
1005 taobo 5000
1003 google 20000
1004 lenovo 5600
1002 apple 8000
SQL> select ta.id,ta.company_name,ta.value,tb.num_of_emp
2 from ta,tb
3 where ta.company_name=tb.company_name(+)
4 order by tb.num_of_emp
5 /
ID COMPANY_NAME VALUE NUM_OF_EMP
----------- ---------------------------------------- ---------------- -----------
1004 lenovo 5000000000 5600
1002 apple 70000000000 8000
1003 google 75000000000 20000
1001 microsoft 85000000000
1005 taobao 100000000000