[{"title":"( 80 个子文件 2.8MB ) 常用SQL语句vb6.0实例源代码","children":[{"title":"SQL语句","children":[{"title":"Filter查找数据","children":[{"title":"frm_movedata.frx <span style='color:#111;'> 1015B </span>","children":null,"spread":false},{"title":"查找数据.vbp <span style='color:#111;'> 1.13KB </span>","children":null,"spread":false},{"title":"frm_movedata.frm <span style='color:#111;'> 6.02KB </span>","children":null,"spread":false},{"title":"22.gif <span style='color:#111;'> 981B </span>","children":null,"spread":false},{"title":"查找数据.vbw <span style='color:#111;'> 60B </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 193B </span>","children":null,"spread":false},{"title":"yggl.mdb <span style='color:#111;'> 112.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"IN范围查询","children":[{"title":"工程1.vbw <span style='color:#111;'> 50B </span>","children":null,"spread":false},{"title":"Form1.frx <span style='color:#111;'> 21B </span>","children":null,"spread":false},{"title":"工程1.vbp <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"Form1.frm <span style='color:#111;'> 7.52KB </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 190B </span>","children":null,"spread":false},{"title":"BOOK.MDB <span style='color:#111;'> 96.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"GROUP BY进行分组排序","children":[{"title":"工程1.vbw <span style='color:#111;'> 49B </span>","children":null,"spread":false},{"title":"Form1.frx <span style='color:#111;'> 21B </span>","children":null,"spread":false},{"title":"bkdy.mdb <span style='color:#111;'> 112.00KB </span>","children":null,"spread":false},{"title":"工程1.vbp <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Form1.frm <span style='color:#111;'> 6.70KB </span>","children":null,"spread":false}],"spread":true},{"title":"ORDER BY进行排序","children":[{"title":"工程1.vbw <span style='color:#111;'> 51B </span>","children":null,"spread":false},{"title":"Form1.frx <span style='color:#111;'> 21B </span>","children":null,"spread":false},{"title":"工程1.vbp <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"Form1.frm <span style='color:#111;'> 7.01KB </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 190B </span>","children":null,"spread":false},{"title":"BOOK.MDB <span style='color:#111;'> 96.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"DELETE删除记录","children":[{"title":"工程1.vbw <span style='color:#111;'> 48B </span>","children":null,"spread":false},{"title":"Form1.frx <span style='color:#111;'> 21B </span>","children":null,"spread":false},{"title":"YPGL.MDB <span style='color:#111;'> 96.00KB </span>","children":null,"spread":false},{"title":"工程1.vbp <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"Form1.frm <span style='color:#111;'> 6.71KB </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 190B </span>","children":null,"spread":false}],"spread":true},{"title":"WHERE子句","children":[{"title":"定义查询条件","children":[{"title":"16.3.frm <span style='color:#111;'> 5.20KB </span>","children":null,"spread":false},{"title":"16.3.vbw <span style='color:#111;'> 49B </span>","children":null,"spread":false},{"title":"16.3.vbp <span style='color:#111;'> 949B </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 189B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"BETWEEN AND区询查询","children":[{"title":"工程1.vbw <span style='color:#111;'> 50B </span>","children":null,"spread":false},{"title":"Form1.frx <span style='color:#111;'> 21B </span>","children":null,"spread":false},{"title":"工程1.vbp <span style='color:#111;'> 1.12KB </span>","children":null,"spread":false},{"title":"Form1.frm <span style='color:#111;'> 7.36KB </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 190B </span>","children":null,"spread":false},{"title":"ZBJXC.ldb <span style='color:#111;'> 64B </span>","children":null,"spread":false},{"title":"zbjxc.mdb <span style='color:#111;'> 320.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"HAVING子句条件统计","children":[{"title":"工程1.vbw <span style='color:#111;'> 48B </span>","children":null,"spread":false},{"title":"Form1.frx <span style='color:#111;'> 21B </span>","children":null,"spread":false},{"title":"YPGL.MDB <span style='color:#111;'> 96.00KB </span>","children":null,"spread":false},{"title":"工程1.vbp <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"Form1.frm <span style='color:#111;'> 7.03KB </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 190B </span>","children":null,"spread":false}],"spread":true},{"title":"SQL数据库","children":[{"title":"database","children":[{"title":"mrsoft_log.LDF <span style='color:#111;'> 5.00MB </span>","children":null,"spread":false},{"title":"book_Log.LDF <span style='color:#111;'> 1024.00KB </span>","children":null,"spread":false},{"title":"book_Data.MDF <span style='color:#111;'> 6.63MB </span>","children":null,"spread":false},{"title":"mrsoft.mdf <span style='color:#111;'> 20.00MB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"SELECT子句","children":[{"title":"统计计算函数","children":[{"title":"16.9.vbw <span style='color:#111;'> 50B </span>","children":null,"spread":false},{"title":"16.9.vbp <span style='color:#111;'> 949B </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 189B </span>","children":null,"spread":false},{"title":"16.9.frm <span style='color:#111;'> 5.32KB </span>","children":null,"spread":false}],"spread":true},{"title":"选择所有列","children":[{"title":"16.1.vbw <span style='color:#111;'> 50B </span>","children":null,"spread":false},{"title":"16.1.frm <span style='color:#111;'> 5.23KB </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 189B </span>","children":null,"spread":false},{"title":"16.1.vbp <span style='color:#111;'> 949B </span>","children":null,"spread":false}],"spread":true},{"title":"选择部分列","children":[{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 189B </span>","children":null,"spread":false},{"title":"16.2.vbw <span style='color:#111;'> 49B </span>","children":null,"spread":false},{"title":"16.2.vbp <span style='color:#111;'> 949B </span>","children":null,"spread":false},{"title":"16.2.frm <span style='color:#111;'> 5.18KB </span>","children":null,"spread":false}],"spread":true},{"title":"给列起别名","children":[{"title":"16.8.vbw <span style='color:#111;'> 50B </span>","children":null,"spread":false},{"title":"16.8.vbp <span style='color:#111;'> 949B </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 189B </span>","children":null,"spread":false},{"title":"16.8.frm <span style='color:#111;'> 5.18KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"UPDATE更新多条记录","children":[{"title":"工程1.vbw <span style='color:#111;'> 49B </span>","children":null,"spread":false},{"title":"Form1.frx <span style='color:#111;'> 21B </span>","children":null,"spread":false},{"title":"工程1.vbp <span style='color:#111;'> 1.05KB </span>","children":null,"spread":false},{"title":"Form1.frm <span style='color:#111;'> 17.71KB </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 190B </span>","children":null,"spread":false},{"title":"GZGL.MDB <span style='color:#111;'> 96.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"OpenSchema添加数据表","children":[{"title":"工程1.vbw <span style='color:#111;'> 50B </span>","children":null,"spread":false},{"title":"Form1.frx <span style='color:#111;'> 2.21KB </span>","children":null,"spread":false},{"title":"工程1.vbp <span style='color:#111;'> 1015B </span>","children":null,"spread":false},{"title":"Form1.frm <span style='color:#111;'> 4.01KB </span>","children":null,"spread":false},{"title":"MSSCCPRJ.SCC <span style='color:#111;'> 190B </span>","children":null,"spread":false},{"title":"DB_KFGL.mdb <span style='color:#111;'> 228.00KB </span>","children":null,"spread":false},{"title":"1.ICO <span style='color:#111;'> 2.19KB </span>","children":null,"spread":false}],"spread":true}],"spread":false}],"spread":true}]