根据 report_no 的整数 从小到大排序
时间: 2024-04-18 11:31:40 浏览: 9
如果 `report_no` 是一个整数字段,您可以使用以下 SQL 查询语句按照 `report_no` 的从小到大进行排序:
```sql
SELECT
sample_id,
item_id,
test_id,
report_no,
report_id,
sample_mass,
batch_number,
customer_name,
customer_id,
sample_name,
sample_no,
factory_number,
test_quantity,
total_fee,
inspection_type,
factory,
receivable_fee,
compile_user_name,
compile_time,
order_no,
audit_user_name,
audit_time,
pass_user_name,
pass_time,
standard_instrument_name,
test_date,
item_state,
print_count,
generate_time,
is_print,
report_state,
final_fee,
node_name,
report_id,
test_result,
test_address,
bas_item_id,
charges_number,
price_id,
item_ids,
settlement_state,
item_name,
sample_remark,
order_remark,
group_name,
group_id,
test_rule,
test_standard,
group_name,
receive_user_name,
query_code,
commission_date,
invoice_title,
product_type,
clarity,
labor_cost,
label_price,
precious_metal
FROM view_sample_info
ORDER BY report_no ASC;
```
这将按照 `report_no` 字段的升序进行排序。请确保 `report_no` 字段的数据类型为整数,否则可能会导致排序结果不准确。