Viewing 12 posts - 1 through 12 (of 12 total)
I got it , thanks for all the reply,
i review my code again and it is working fine now. select top 3 count(UUT_SN) as Total_Fail,Fail_Description,Station_No...
July 16, 2018 at 8:00 pm
July 16, 2018 at 7:42 am
select top 3 count(UUT_SN) as Total_Fail,Fail_Description,Station_No from Test_table
WHERE SQLDateTime >= '2018-07-01'
AND SQLDateTime <= '2018-07-13 'AND Station_No in (19,20,21,22,23,24)and Fail_Description NOT LIKE '%[PASS]%'
group by Fail_Description,Station_No
ORDER...
July 16, 2018 at 6:57 am
BONITO - Monday, July 9, 2018 7:51 AMSir thanks a lot !!
it works !!!!
Sir what about i want to add the Yield...
July 9, 2018 at 7:57 am
June 30, 2018 at 1:50 am
what is the criteria to check if its a "duplicate". How did you arrive at aa5 and aa4 in the above example as eligible for ReTest?
...
June 29, 2018 at 8:10 pm
Hi Sir,
Can i change my query to count how many duplicate records in my col1 ?
example:
Col1 Col2
aa1 Fail
aa2 Fail
aa3 Ok
aa4 Fail
June 29, 2018 at 2:31 am
Hi Sir,
I don't understand the code below, 'Join data b' ????
I am only working in 1 Table MyTableName, where should i join it?
sorry i'm a newbie.
June 29, 2018 at 12:53 am
June 29, 2018 at 12:02 am
I can't use where because i have another data to query,
Total_input | Total_Ok | Total_Fail | True_Fail
5 | ...
June 28, 2018 at 10:25 pm
Viewing 12 posts - 1 through 12 (of 12 total)