Factory number have no miscellaneous since liquid
H8708 2 0 0 0 0
H8708 1 0 0 0 0
H8718 2 0 0 0 0
H8718 2 0 0 0 0
K7138 2 0 0 0 0
K7138 2 0 0 0 0
K8698 2 0 0 0 0
K8698 2 0 0 0 0
I am a beginner, a database as shown above, to give priority to with factory number field, the factory number is the same but the other parameters of different data to filter out, but I don't know should how to set up the program, please the teacher give directions, thank you very much!!!!! Total, according to have thousands of lines look very tired,
USE AAA
GO the TOP
The DO WHILE NOT EOF ()
STOR factory number TO AAA
STor have TO BBB
No TO sTor CCC
STor miscellaneous TO DDD
The sTor TO EEE
STor fluid TO FFF
DO CASE
Case BBB<& gt;" 0 ". AND the factory number==AAA
DISP
Case CCC<& gt;" 0 ". AND the factory number==AAA
DISP
Case DDD<& gt;" 0 ". AND the factory number==AAA
DISP
Case EEE<& gt;" 0 ". AND the factory number==AAA
DISP
Case FFF<& gt;" 0 ". AND the factory number==AAA
DISP
ENDC
The SEEK AAA
ENDD
Copy to data A.x ls type xl5

CodePudding user response:

Select yes, no, miscellaneous, since, fluid is distinct from table group by factory number

CodePudding user response:

You can refer to the first floor, filtered with Mysql statement is also a good way!