本文介绍了如何使用if else条件编写过程的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! SELECT ' - 全部 - ' as farmername union 从中选择 farmername k_Master_AddHatchingFarmer 其中​​ attrited = ' False' order by farmername 选择 ' - 全部 - ' as agentname union SELECT agentname 来自 k_Master_AddHatchingAgent 其中​​ attrited = ' Fal se' 订单 按 agentname 选择 ' - 全部 - ' as farmername union 选择 farmername 来自 k_Master_Farmrecord 其中​​ attrited in ( ' false') order by farmername 这三个条件, 如果农名是来自前端,那么执行1 st条件 否则如果agentname 2声明 else 3 rd statement 请帮帮我解决方案 SELECT '--All--' as farmername union select farmername from k_Master_AddHatchingFarmer where attrited = 'False' order by farmernameselect '--All--' as agentname union SELECT agentname from k_Master_AddHatchingAgent where attrited = 'False' order by agentnameselect '--All--' as farmername union select farmername from k_Master_Farmrecord where attrited in('false') order by farmernameThese are three condition,if farmername is from front end,then execute 1 st conditionelse if agentname 2 statementelse 3 rd statementplease help me 解决方案 这篇关于如何使用if else条件编写过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
07-05 01:15