select distinct p. ihao, a. igid, a. d. JBH, c.s. pid, c.s. PBH, c.s. PMCH, p. ihao, c.s. hengccj c.d w, c.s. HPGG, 
, b.j whname, b.h wname, p. ihao, b.s XRQ,, dc kname, c.p izhwh 
The from (select spid, pihao pici, DJBH from 
(
The select row_number () over (partition by spid, pihao order by pici) number, * from yw_jxmx where DJBH like 'jhe %' 
) t 
Where t. number='1') tt 
Inner join yw_jxhz on tt. "DJBH=a. d. JBH 
Inner JOIN YW_JXMX b (nolock) ON a. d. JBH=b.d JBH and tt. The spid=b.s pid 
Inner JOIN spzl_v c (nolock) ON b.s c.s. pid and the pid=a. igid=SAN Antonio igid 
Inner JOIN zl_ckzl d (nolock) ON biggest kid=, dc kid 
Inner join zl_jwhzl e (nolock) on the biggest kid=e.c. with our fabrication: kid and b.h wid=e.h wid and b.j whid=e.j whid 
Where a. igid='000' 
The order by c.s. pid 

Query as above, but every time I click on the query is executed, the results of the query will change the number of lines, is a separate database, and, why the same query will appear this kind of circumstance!

CodePudding user response:

No other people with you this library?

CodePudding user response:

Is there in the modified data

CodePudding user response:

reference 1/f, gypsy song response:

the library you have no other people in use?

there is no other in use, the database is my restore backup of the database of a test, just I a person is in use, I immediately execute query is a query, such as complete click again on the execution, and then found out the data lines will change

CodePudding user response:

Whether yw_jxmx pici has repeated this list,

CodePudding user response:

reference 4 floor RINK_1 response:

is yw_jxmx pici has repeated, this list

batch is didn't have to repeat, his article is based on date + commodity number, today for documents, for example, three messages inside, 2019111900001201111000, 02201111000, 03, so that the generated