摘要:
1.mysql 中limit的使用 1.1 例子:select * from tb_user order by createdTime limit 0,15; 从第0行开始返回,返回15条数据; 下一页,应该是从第15条开始返回,返回15条数据:select * from tb_user order 阅读全文
摘要:
1.Failed to load the JNI shared library "c:\java\jdk_6.0_32\bin\...\jre\bin\server\jvm.dll"出错原因:安装了64位jdk,eclipse是32位的,所以启动不起来2.eclipse如何卸载已经安装的插件依次点击菜单:Window-->Preferences-->Install/Update-->右侧有个链接 Uninstall or update 点击就转到安装的插件列表界面 阅读全文
摘要:
1.oracle查询结果去除重复项SELECT DISTINCT * FROM TABLE_NAME2.合并查询结果select id,name from wg_personunionselect id,name from wg_superUsers从person表和superuser表中查询到的结果合并3.递归查询START WITH PID = :id CONNECT BY PRIOR ID = PID一般和union语句结合使用:START WITH PID = :id CONNECT BY PRIOR ID = PID unionselect id from wg_depart whe 阅读全文