lyfz_repos/经典版源码/document/数据库维护脚本/跨年转数据/查询不完全重复.sql

--.singleincome
use db select count(*),name from singleincome 
group by [name],[money],[dat],[bz],[renyuan1],[renyuan2],
[renyuan3],[sale2type],[paytype],[phone],[payed],[balance],
[pinyin],[financecheck],[count],[time]

use db select count(*),name from singleincome_back 
group by [name],[money],[dat],[bz],[renyuan1],[renyuan2],
[renyuan3],[sale2type],[paytype],[phone],[payed],[balance],
[pinyin],[financecheck],[count],[time] having(count(*) > 1)

use [2014] select count(*),name from singleincome 
group by [name],[money],[dat],[bz],[renyuan1],[renyuan2],
[renyuan3],[sale2type],[paytype],[phone],[payed],[balance],
[pinyin],[financecheck],[count],[time]

use db select * from singleincome_back where name = 'Ö¤¼þÏà' order by renyuan1

--.[gudingfeiyong]
use db select count(*),name from [gudingfeiyong] 
group by [name],[money],[dat],[bz],[renyuan1],[renyuan2],[financecheck],[time],[financecheck2],[financecheck3],[hasphoto]

use db select count(*),name from gudingfeiyong_back 
group by [name],[money],[dat],[bz],[renyuan1],[renyuan2],[financecheck],[time],[financecheck2],[financecheck3],[hasphoto]
having(count(*) > 1)

use [2014] select count(*),name,dat from gudingfeiyong 
group by [name],[money],[dat],[bz],[renyuan1],[renyuan2],[financecheck],[time],[financecheck2],[financecheck3],[hasphoto]
having(count(*) > 1)

use [2014] select * from gudingfeiyong where name = 'ÔÓ·Ñ' and dat = '2011-05-27' order by renyuan1