Stay hungry, Stay foolish!

[code="java"]select * from (select temp_.*, rownum r_ from (select * from gnete_pay) temp_ where rownum 5[/code]

[color=olive][b]一、The p6spy agent can print SQL time, See[/b][/color] [url]http://www.p6spy.com[/url] 二、[color=olive][b]p6spy can join with Log4j[/b][/color] 三、[color=olive][b]To install P6Spy, com...

[b]LEFT JOIN[/b] [list] [*][color=olive]1、对符合on条件的“左表”和“右表”做笛卡儿积返回[/color] [*][color=olive]2、返回不符合on条件的“左表”行，其中的“右表”值全返回null[/color] [*]注：以左表为准 [/list] [b]RIGHT JOIN[/b] [list] [*][color=olive...