当前位置：网站首页>Reasons and solutions for more data entries than the original data table after left join/inner join

Reasons and solutions for more data entries than the original data table after left join/inner join

2022-07-21 11:47:00 【Qingxiao】

Page one ：

select vendor, application,applicationversion,filename ,fileversion, lastuse from `ASIA`.applications
where INSTR(vendor, "") and  INSTR(application , "") and  INSTR(filename, "") and lastuse< 1597741978 and lastuse> 1595149978
GROUP BY vendor ,application ,applicationversion ,filename
ORDER BY vendor desc LIMIT 10 OFFSET 0;                           #  No, join surface

Page 2 ：