sql 按照in查询条件拍寻

最新推荐文章于 2022-09-04 19:33:02 发布

qq_43060784

最新推荐文章于 2022-09-04 19:33:02 发布

阅读量148

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/qq_43060784/article/details/103893901

版权

sql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

SELECT
driver_phone,
driver_name,
plate_num,
owner_unit,
carrier_unit,
carrier_name,
carrier_phone,
goods_name,
goods_weight,
receiving_weight,
transport_amount,
freight_amount,
total_amount,
paid_total_amount,
payment_time,
loading_province,
loading_city,
loading_area,
unloading_province,
unloading_city,
unloading_area,
CAST(pay_status AS type)pay_status,
create_time
FROM
w_biz_waybill
WHERE
waybill_code IN (
“YD0.7149956253314439”,
“YD0.9984902861237118”,
“YD0.1360347477238607”,
“YD0.36716155043505727”,
“YD0.9273281775872855”,
“YD0.1360347477238607”,
“YD0.11746987605502224”,
“YD0.5815626141910709”,
“YD0.4146019536816584”,
“YD0.6681411693531117”,
“YD0.7143244078502008”
)
ORDER BY
field(
waybill_code,
“YD0.7149956253314439”,
“YD0.9984902861237118”,
“YD0.1360347477238607”,
“YD0.36716155043505727”,
“YD0.9273281775872855”,
“YD0.1360347477238607”,
“YD0.11746987605502224”,
“YD0.5815626141910709”,
“YD0.4146019536816584”,
“YD0.6681411693531117”,
“YD0.7143244078502008”
)