xuty@blog

摘要： public Object createTable(){ //打开或创建test.db数据库 db = context.openOrCreateDatabase("symptom.db", Context.MODE_PRIVATE, null); db.execSQL("DROP TABLE IF EXISTS zzk"); //创建person表 db.execSQL("CREATE TABLE zzk (FATHER varchar2(4), CHILD varchar2(4))"); //插入数据 upda... 阅读全文

摘要： SELECT father from zz group by father不知道为什么之前要想这么复杂。。。。。。。。。。。。。。SELECT * FROM (select Father , Row_number() OVER (PARTITION BY Father ORDER BY Father) rn from zz ) where RN = 1 阅读全文