sql语句

1.oracle分页查询

sql = "SELECT * FROM (SELECT A.* ROWNUM RN FROM (SELECT * FROM table_name) A WHERE ROWNUM <= 20) WHERE RN >= 1";

中间括号内放原始sql语句；

（1,20）代表1到20行；

2.关联查询

SELECT "+zb+",NSRSBH,NSRXX.NSRMC FROM FXZB_SJ_XA inner join NSRXX on FXZB_SJ_XZ.NSRSBH = NSRXX.NSRSBH ORDER by desc

用table.field然后将条件写上inner join NSRXX on FXZB_SJ_XZ.NSRSBH = NSRXX.NSRSBH

order by desc降序排列