任意选择保留最小的PIC_ID。另外，请避免使用隐式连接语法。
SELECt U.NAME, MIN(P.PIC_ID) FROM USERS U INNER JOIN POSTINGS P1 ON U.EMAIL_ID = P1.EMAIL_ID INNER JOIN PICTURES P ON P1.PIC_ID = P.PIC_ID WHERe P.CAPTION LIKE '%car%' GROUP BY U.NAME;
任意选择保留最小的PIC_ID。另外，请避免使用隐式连接语法。
SELECt U.NAME, MIN(P.PIC_ID) FROM USERS U INNER JOIN POSTINGS P1 ON U.EMAIL_ID = P1.EMAIL_ID INNER JOIN PICTURES P ON P1.PIC_ID = P.PIC_ID WHERe P.CAPTION LIKE '%car%' GROUP BY U.NAME;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
