TypechoJoeTheme

Strjson博客-专注于各种精品源码、精品软件、技术教程分享、黑客技术、破解教程(爱你在心口难开、没事写一写)

统计

Mysql联表查询按照某个字段分组并取每组的前8条数据

子沫博主
2021-01-18
/
1 评论
/
699 阅读
/
0 个字
/
百度已收录
01/18
本文最后更新于2021年01月18日,已超过1205天没有更新。如果文章内容或图片资源失效,请留言反馈,我会及时处理,谢谢!
SELECT
    t1.*
FROM
    (
        SELECT
            sqrt(
                (10 - ec.l) * (10 - ec.l) + (10 - ec.a) * (10 - ec.a) + (10 - ec.b) * (10 - ec.b)
            ) AS distValue,
            em. NAME material_name,
            ec.*
        FROM
            ea_color AS ec
        JOIN ea_material AS em ON em.id = ec.material_id
        WHERE
            ec.delete_time IS NULL
        AND ec.material_id IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 8)
    ) AS t1
WHERE
    (
        SELECT
            count(*) + 1
        FROM
            (
                SELECT
                    sqrt(
                        (10 - ec.l) * (10 - ec.l) + (10 - ec.a) * (10 - ec.a) + (10 - ec.b) * (10 - ec.b)
                    ) AS distValue,
                    em. NAME material_name,
                    ec.*
                FROM
                    ea_color AS ec
                JOIN ea_material AS em ON em.id = ec.material_id
                WHERE
                    ec.delete_time IS NULL
                AND ec.material_id IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 8)
            ) AS t2
        WHERE
            t1.material_id = t2.material_id
        AND t2.distValue < t1.distValue
    ) <= 8
AND t1.delete_time IS NULL
ORDER BY
    t1.material_id,
    t1.distValue
朗读
赞(0)
赞赏
感谢您的支持,我会继续努力哒!
版权属于:

Strjson博客-专注于各种精品源码、精品软件、技术教程分享、黑客技术、破解教程(爱你在心口难开、没事写一写)

本文链接:

https://jpgke.com/jiaocheng/174.html(转载时请注明本文出处及文章链接)

评论 (1)
  1. str 闲逛
    Android · Google Chrome

    {!{data:image/webp;base64,UklGRjoNAABXRUJQVlA4WAoAAAAQAAAADQEAKwEAQUxQSFcMAAAB8Ibt/yKn/f89cYdghVRxCO4ui7sVgrvDu4K7u7tLcHd39xZ3C6VocYIEgj1uPGZ3Zue1r83cehMREyDf/P/N/9/8/83//7/gqv0DnYRVAAY6B80AYL9z8MRZKAFu7RjMMUjmFCR9T+PEKewDTuEY3KMJot2EEzeGNE7lhwSDs+tnPvj6jCYZ/IyTtEhsXO5c2HKf8NyAb+2p4kfEeEnl7BQGYLMvOOkBgEX+w68AcFts3B4AXviC/Hs8whq/IYTa2KkzPfAFIq6B+z3AnRT+QaKnlMhOo2m+bxCR5A3m/2MEzPQLmgDAVrHzSvrNZ3DQfiOM9QdWURNbnaDKPkWkWYQBZuovMJzi2+oRZfMxUviyATZprwMArBU7B4AT+RpJetwAB3S3jerYKic9FB880ADp9ZYGAL7EtlUNOuqLZKDBA711p6Vi64601CfJBsJwrR2i6vaaQCO8ESMwa6fKwU3adVqwYnLIxktPru2f5bKLrCY00FhWAHgXw17nqb2JqMkzNa/ZqufY+ZuP33gBS4PtkjycwrPrazDNE3s/pd8lIEvLuh36TVy87eStF/D+KrtIB8I6fZ2hyrYKzBtOoa9h7wG2kZt0XVv5AeB5VHukLPXbmqeP30LN+ZntU5XCoulqHE0Tb/9UvuPMA//Bxs8eP7u4Y8nsGSvW9Gldv2onlyuV2DgpoZiublAFb6QMORl6D3Z8+d/T2yvH9Wpds1hQ8iii9jEapSkXADwQ6ytugDcjHj89GzK6R6uaxTKniC4+dDWFamomTbAqSa/LsPTDK5pb8Ofo4qM30DVNPaCy1pSa8xZmX51cOrhL/e9kM1US3/03bdZTJQAIFQsLrLoAj0O3jm9bJrW4vUBBvisjuLSeFtEYU8m7X4Gnb9a3jyUmX1Fs3/UHvRI9h1FJE7XXweP97VOI6ZQAcFN89waap6daAHBZPM094iY8fT02v1hZkLYpVW3yzqLeeE219LSGRnrQdDM8PlE/mlhbj6aolOcpEF7WutIA8D6RlmJ8oeLupsDTU1OyiuU9qbNKIQDQzrqjtFK03BgAzohbF9z/3TObeHMG1VTpJv1hWQC4tZ620lBTd4flFy9vp5wKFQAHWXbKII2WEoGLuJPZQMRcl3j/ISVSqCvdE6vrgLeJljvT3+KpyyV2TPIVwCtReCOFWBUADg3U0xMa5JFNywPAM5WeU32rFhm0EC0HgQvYrxadUKgk+GeLaoDXiJ670TOxf1NaotAQOiPWBrykd4GaOkQ9FfiNZih0mMZYNAHcV/ScD/yLAj1pjDpxwDWsqQE+JpoeREdEwaE0QJ3K9DW5JQEXDQJ1dZo6qDCRuqgzk/aIpX+BB4qmi4NTqDCX2qhzh0ZbEXM++I7oehxtExVXUAN1nlAnC1LthGGgtq5TIyW2UDV1nlFac4Uuw3CD6Lo8OECJA1RKmegRlMBUrdcwHC7ankUrRMlTlE+Z7wHgjZj9A4bv6oq+H1BtNa5RkDK56JaZMTC8UVT0XR0A3sZR4z79pEx5OupZ/Bsw3J9GNL6UZouaryixMk1onUfp/oLhklii8zCqqsgXiq5MV5rhSbHrMBwlWq8LAA+jqhEfAN6LXV0ul5kxNNCD4HAY9hS9r6dJomZKemqXYOBdIRMLqYO7sTD8OET0HvsLlVMkHf1jk8D/AOw3sZ1qu1kPw6sFRPNNAeCaKJqLLthkDCw4TSUMEq+G4Z6fRffbabQqxeiYPWJ/oj4m7lEQVX8Pw4XRRfcB4BKqVKRd9rgEAK/imoigZCJyA8Y7Rf8D6YyoGkxr7ZDkJniOeJ4UAN6IyAoYdxM/MIyGKNOcFtqgwHVweEoTQXRPRF66eb1lQM20mnOBCyrzu00awriTmGxKD0XkgRvDN3OqJdPYBHoqyi6jDd5KsBnGwWL2V7ohIvVee8RXp2krlDqps4Q2eidgBNz+JqZb0CLhbltMAKGZ9FQb/J06k6iTVxpehPHZaGK+O403EEm18NRDj/BhWRwdLaYtou5cau2FHMvhdoJYOYr6uOGkFfrdiHAD3Miqn0SvqY5CK6i+ZdH6vIbx3Rpi6Txq6xEnbrHuoxHe1dNOewAIj67QFqpm1YBQGIcvCxBrN1AtUyISs8NTA3zIpJsdNFMU3k+lrKl5DG5npRarj5DLChHZaYCTmkkFLqnS31TAijq74PZoVbH+GmW3SH77TO/T6aU33RCVr1AWcw33w21Yr6jixaf0o1VS6xMAHNTLKeqn1F1KZabZEbg/mV28Co5jmYyhd1rJBc6p1AtK7tnYq3B/vZd4Nxm9EutzELQyhvaJ0hEU112C+svew/3ehuLtjBTqhXgUoZU79JtSMQHgkxhm6LIHnm6uKd4vQie9kIRe6KQk+GelEtNLEXGNOAWPV5YXO1ajrV4IpIc6mUsrROmf6P6v02/C873FxJ4taLEXUtNtnbynhmoF0Vd4Hnawidi1O030Qia6opHhAPAwgUpJ620gj8+PqRBT7DuK+nshB53VyFVaIapGKTv8CMzu75pb7D2PfvNCAbqgj6bgOmrk+H31Y5j8sq7pj2L7c1TfC+Pojjain6ILYv+fGoeEweyHpVVjiopPqbwXLtFGbXQEu2wW2GD2NVi4XlSlT2J9R/DPukh+m+aKjb+rM+UMTO/ZTLNViREB4I4XrtMc0eVgAHifwy5Jqo06AtPXJlVNLGtprSqpAGCPdT3AP+si40saLbYstfvCe5gNv/W/1MLraKMqRWmJdXdohuhyKgA8+MkGlee9gtnPO/q6ootbg8aq1KWxlg0Ap9FFQXBP8XLU2kuew+y5sTWSiccnqaQqnamLZY9osuhyKV2K55V4DZc8h8kni5ulE9P3KL0q46iRVQPB6XVRCdxWrE/ScMlzmNzbI49YGfcrxVNlBZW16iWNF11up0Nives6PL93pHYssTgDADwTVQ9RDosGgoN00RAc7AV4fLBfIfFiSTqvTCiltCicJokuP9BGscPm9hnEu41oqzIfAEREtWYgOKsuloHLeGMyhS8NTiJe70GzVAkEgH/F2q80VTSZBXxQvDpq/YzyYstJ1E+VvHTSmmHgnLq4SF9qeMe+a6i5KtVpkyXJ79B+0WRb8HDxjceovCrjaZElE8AtNJEOfEl85L+UTZXDNNeKCuDloslFBvV8RLTPlFSVi1TBgiiHKfRHTUwDbxIf+QsAhImiST4DCBcL+4Jbih6DYSi+sghdVqU8AGy1IG84rRI9/g7DDj6jDu1UpRf1t2A9AITl0ILrLQxDxWd2phBVVlFFc+3APUSLMD4Ty3eMo6Gq3KJAU6nv0j7RyeXk4jtXUgdFfgSAa2J6Dri0Ji7S27LiQ49QDUVq0kJTtcGjRZe3w16uTSC+9B/Kr8gw6mgKfD5AG743gn5UZBe5zIw3qCv+ekoACI+qyBsAnwJMZAdfEr89L90QNXMCwDUxec/A5b9VpwOKDKZDJnqCB4r/3oe2KrKa5nhWArxf/PhdtFORfymnRzGPGWTy57bRdDWKAMBL8XgsuJf48wepphr9aL1Hw8H7xa//h3KrsYs6ehIMQ/Hr43ymZErE+ECFPAiGYVX/LiMAvBElywPAy2jugmF4WPz7cnRRjdG0QdyOhOEh8fNb0RY17lBvN+1guEr8/UE0TY3PVMaoHwxXid8fQt2VqApOaBACw7/E/99D9ZWYSftERGrfheEliQRep6JK3KPqIk0PwHiyRAbDKZUKFQAgPFaWR3DbTyKDPwBARDQVZlNIx3dwO1QihYXphqgYRo/h9mEHiRzWo90qdIfHp9pIZLE7hagwx5M33STyOI0GqXDd3ech8SQSuZlaKVAabh8VlEjlTaqgwDY3p5JJ5PITZVHgML3G+iCJXGYBJ1RgP4AXKVwS2axDz0XBzJcQXlQin4NouQoSK01RiYSuoW5KRFKvUinHIBk4mWNQkkLFMfyTVjkHs6mnc3CUKjkHr+gnxyAjANwRxzCY1jkHQ2igc7CBajkHoZTBMUgAAPfEMSxCW52DOTTSOQilPs7BE8rnGCQCx3EMstMjcQyr0nHn4Dda7hyMphHOwUpq7xwcpyrOwUPK4RjEBSdxDILokTiGFemEczCIdjoHO2mXc7CVpjoHx6iKc/CAsjgGAeAEjkFOeiCOYQ067Bx0pIXOwQQa7Bysp5bOwVkq6xy8pAzOwSUAD2I7B+MB9BQHMXj97/LN/9/8/83/jiYAVlA4ILwAAACQFACdASoOASwBP3G42WW0ryunICgCkC4JaW7hd2EbQAnsA99snIe+2TkPfbJyHvtk5D32ych77ZOQ99snIe+2TkPfbJyHvtk5D32ych77ZOQ99snIe+2TkPfbJyHvtk5D32ych77ZOQ99snIe+2TkPfbJyHvtk5D32ych77ZOQ99snIe+2TkPfbJyHvtk5D32ych77ZOQ99snIe+2TkPfbJyHvtk5D32ych70gAD+/60eAAAAAAAAAAAAAA==}!}

    2021-04-09 回复

互动读者

人生倒计时

今日已经过去小时
这周已经过去
本月已经过去
今年已经过去个月

360实时热点

  • 获取失败!

标签云

最新回复

  1. 试试看闲逛
    2021-12-14
  2. 555闲逛
    2021-12-07
  3. def闲逛
    2021-11-28
  4. 紫夜闲逛
    2021-11-28
  5. 666闲逛
    2021-10-05