81,095
社区成员
发帖
与我相关
我的任务
分享
SELECT MAX(ABS(tb1.value-tb2.value))AS OOB_MAX,SUM(ABS(tb1.value-tb2.value)) AS OOB_SUM FROM (
SELECT * FROM tcolplanhistory WHERE NAME='LPD2_Count' AND SUBSTRING(creattime,1,10)=CURRENT_DATE() AND lotid='34A90I700' ORDER BY CREATTIME DESC LIMIT 25) tb1
LEFT JOIN (
SELECT * FROM tcolplanhistory WHERE NAME='LPD2_Count' AND SUBSTRING(creattime,1,10)=CURRENT_DATE() AND lotid='34A90I700' ORDER BY CREATTIME ASC LIMIT 25) tb2
ON ((SELECT RIGHT(tb1.waferid,2)+0) +(SELECT RIGHT(tb2.waferid,2)+0))=26
String SQL = "SELECT MAX(ABS(tb1.value-tb2.value))AS OOB_MAX,SUM(ABS(tb1.value-tb2.value)) AS OOB_SUM FROM ("
+ " SELECT * FROM tcolplanhistory WHERE NAME='LPD2_Count' AND SUBSTRING(creattime,1,10)=CURRENT_DATE() AND lotid='" + lotID + "' ORDER BY CREATTIME DESC LIMIT 25) tb1"
+ " LEFT JOIN ( "
+ " SELECT * FROM tcolplanhistory WHERE NAME='LPD2_Count' AND SUBSTRING(creattime,1,10)=CURRENT_DATE() AND lotid='" + lotID + "' ORDER BY CREATTIME ASC LIMIT 25) tb2"
+ " ON ((SELECT RIGHT(tb1.waferid,2)+0) +(SELECT RIGHT(tb2.waferid,2)+0))=26";
try:
public void showHtml(HttpServletRequest request,HttpServletResponse response) throws IOException
{
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("aaaaaaaaaaaa");
}