count(policy_no), count(sub_policy_no), count(insured_type), count(insured_name), count(insured_document_type), count(insured_document_no), count(insured_employee_number), count(insured_birthday), count(insured_sex), count(contact_number), count(contact_address), count(email), count(relationto_applicant), count(relationto_insured), count(main_insured_sign), count(edor_no), count(insurance_time), count(effective_date), count(expiration_date), count(insurance_premium), count(scheme_code), count(scheme_name), count(sub_policy_status), count(surrender_time), count(company_account), count(division_code), count(division_name), count(network_code), count(network_name), count(validity_flag), count(del_flag), count(create_by), count(update_by), count(create_date), count(update_date), count(remarks), count(source_system), count(all_insurance_time), count(all_effective_date), count(all_expiration_date), count(company_code), count(company_name), count(protocol_code), count(protocol_name), count(channel_code), count(channel_name), count(product_code), count(product_name), count(all_insurance_premium), count(sales_code), count(sales_name), count(project_code), count(project_name), count(transaction_source), count(policy_type), count(policy_nature), count(policy_status), count(payment_method), count(paymen_period), count(brokerage_rate), count(technical_service_rate), count(payment_type), count(all_surrender_time), count(applicant_type), count(applicant_name), count(applicant_document_type), count(applicant_document_no), count(member_id), count(applicant_birthday), count(applicant_sex), count(applicant_contact_number), count(applicant_contact_address), count(applicant_email), count(total_insurance_day_cnt), count(cur_insurance_day_cnt), count(cur_insurance_amt), count(product_category_name), count(product_subclass_name), count(product_policy_year), count(project_type_name),
时间: 2024-02-24 20:56:50 浏览: 62
根据你提供的字段列表,我猜测你想提取这些字段的数量。如果是这样的话,你可以使用以下 SQL 查询语句来提取这些字段的数量:
```sql
SELECT
COUNT(policy_no),
COUNT(sub_policy_no),
COUNT(insured_type),
COUNT(insured_name),
COUNT(insured_document_type),
COUNT(insured_document_no),
COUNT(insured_employee_number),
COUNT(insured_birthday),
COUNT(insured_sex),
COUNT(contact_number),
COUNT(contact_address),
COUNT(email),
COUNT(relationto_applicant),
COUNT(relationto_insured),
COUNT(main_insured_sign),
COUNT(edor_no),
COUNT(insurance_time),
COUNT(effective_date),
COUNT(expiration_date),
COUNT(insurance_premium),
COUNT(scheme_code),
COUNT(scheme_name),
COUNT(sub_policy_status),
COUNT(surrender_time),
COUNT(company_account),
COUNT(division_code),
COUNT(division_name),
COUNT(network_code),
COUNT(network_name),
COUNT(validity_flag),
COUNT(del_flag),
COUNT(create_by),
COUNT(update_by),
COUNT(create_date),
COUNT(update_date),
COUNT(remarks),
COUNT(source_system),
COUNT(all_insurance_time),
COUNT(all_effective_date),
COUNT(all_expiration_date),
COUNT(company_code),
COUNT(company_name),
COUNT(protocol_code),
COUNT(protocol_name),
COUNT(channel_code),
COUNT(channel_name),
COUNT(product_code),
COUNT(product_name),
COUNT(all_insurance_premium),
COUNT(sales_code),
COUNT(sales_name),
COUNT(project_code),
COUNT(project_name),
COUNT(transaction_source),
COUNT(policy_type),
COUNT(policy_nature),
COUNT(policy_status),
COUNT(payment_method),
COUNT(paymen_period),
COUNT(brokerage_rate),
COUNT(technical_service_rate),
COUNT(payment_type),
COUNT(all_surrender_time),
COUNT(applicant_type),
COUNT(applicant_name),
COUNT(applicant_document_type),
COUNT(applicant_document_no),
COUNT(member_id),
COUNT(applicant_birthday),
COUNT(applicant_sex),
COUNT(applicant_contact_number),
COUNT(applicant_contact_address),
COUNT(applicant_email),
COUNT(total_insurance_day_cnt),
COUNT(cur_insurance_day_cnt),
COUNT(cur_insurance_amt),
COUNT(product_category_name),
COUNT(product_subclass_name),
COUNT(product_policy_year),
COUNT(project_type_name)
FROM your_table_name;
```
请将 `your_table_name` 替换为你想要查询的表的名称。这将返回一个包含每个字段数量的行。
阅读全文