需求:删除station_id.ab_data_time.item_code_id.data_cycle.ab_value 字段重复的记录 #查询重复的数据 select b.id,b.station_id,b.ab_data_time,b.item_code_id,b.data_cycle,b.ab_lable,b.ab_value from d_abnormal_data_yyyymms b where (b.station_id,b.ab_data_time,b.item_code_id,
/** *查看目标表中已添加的索引 * */ --在数据库中查找表名 select * from user_tables where table_name like 'tablename%'; --查看该表的所有索引 select * from all_indexes where table_name = 'tablename'; --查看该表的所有索引列 select* from all_ind_columns where table_name = 'tablename'; /* *创建索引
汉化版:工具-首选项-用户界面-编辑器-自动替换-定义文件 英文版:Tools->Perferences->Editor中Autoreplaces选择配置的shortcuts 常用快捷键设置 st = select st.*,rowid from sa = select sa.*,rowid fromsb = select sb.*,rowid from sc = select sc.*,rowid fromsd = select sd.*,rowid from se = select se.