作者热门文章
- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
由于某种原因,我只得到了一个可以看到的重复行,但无法真正查明查询中哪里出了问题。
$stmt = $mysqli->query("
SELECT DISTINCT vendors_tbl.email AS email,
(vendor_avails_tbl.standard_pricing - vendor_loc_tbl.offpeak_time_pricing) AS best_margins,
vendor_loc_tbl.location_id AS locationID,
vendor_loc_tbl.loc_img_path AS locImg,
vendor_loc_tbl.offpeak_time_pricing AS offpeak,
vendor_loc_tbl.address1 AS address1,
vendor_loc_tbl.address2 AS address2,
vendor_loc_tbl.zip_code AS zip,
vendor_loc_tbl.geocodes AS geo,
vendor_loc_tbl.has_valet AS valet,
vendor_loc_tbl.has_transport AS transport,
vendor_loc_tbl.has_wheelchair AS wheelchair,
vendor_loc_tbl.has_desk AS desk,
vendor_loc_tbl.has_24hours AS open24hrs,
vendor_loc_tbl.has_covered AS covered,
vendor_loc_tbl.has_security AS security,
(vendor_avails_tbl.available_economy + vendor_avails_tbl.available_standard + vendor_avails_tbl.available_midsize + vendor_avails_tbl.available_truck_suv) AS avail_total,
vendor_avails_tbl.standard_pricing AS standard_pricing, 69 *
DEGREES(ACOS(COS(RADIANS($e_lat))
* COS(RADIANS(SUBSTR(vendor_loc_tbl.geocodes, 1, 10)))
* COS(RADIANS($e_lon) - RADIANS(SUBSTR(vendor_loc_tbl.geocodes, 13)))
+ SIN(RADIANS($e_lat))
* SIN(RADIANS(SUBSTR(vendor_loc_tbl.geocodes, 1, 10))))) AS distance_in_m
FROM vendors_tbl
INNER JOIN vendor_loc_tbl ON vendor_loc_tbl.vendor_id = vendors_tbl.vendor_id
INNER JOIN vendor_avails_tbl ON vendor_avails_tbl.location_id = vendor_loc_tbl.location_id
WHERE vendor_avails_tbl.available_standard > 0
ORDER BY vendor_loc_tbl.override_level DESC, best_margins DESC, distance_in_m ASC
LIMIT 5
");
最佳答案
在某些情况下,使用GROUP BY
语句比使用DISTINCT
更好。在您的示例中,您应该至少按一个列添加一个组(一些唯一,例如 id)。当您在查询中使用聚合时,最好使用分组依据,而仅使用联接时 - 不同就足够了。
关于php - 我的 MySQL SELECT 查询返回相同行的多个,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/36938210/
现在我正在尝试实现 flash programming specification对于 PIC32MX。我正在使用 PIC32MX512L 和 PIC32MX512H。 PIC32MX512L最终必须
我是一名优秀的程序员,十分优秀!