1、case by case

case by case發(fā)音

英：　　美：

case by case中文意思翻譯

常用釋義：具體問(wèn)題具體分析

具體問(wèn)題具體分析；就事論事

n.具體問(wèn)題具體分析，就事論事

case by case雙語(yǔ)使用場(chǎng)景

1、The department said it would evaluate more school closings on the case - by - case basis.───衛(wèi)生部門(mén)表示,在個(gè)案的基礎(chǔ)上,他們將評(píng)估臨時(shí)關(guān)閉更多學(xué)校的可能性.

2、Fairness and justice in a jurisdiction are realized case by case being settled properly.───司法的公平和正義是通過(guò)案件逐一得到妥善解決予以實(shí)現(xiàn)的.

3、ReturnWe will accept item return on a case by case basis within 2 weeks of delivery.───ReturnWe將 接受逐案內(nèi)項(xiàng)目回報(bào)的基礎(chǔ)2個(gè)星期交貨.

4、As a result, to an individual case by case.───因此, 每一情況要個(gè)別協(xié)調(diào).

5、Players breaking curfews will be subject to penalty, which will be determined a case - by - case basis.───打破宵禁的隊(duì)員將會(huì)受懲罰, 到時(shí)將根據(jù)具體情況實(shí)施.

6、The University Judicial Committee committee decides punishment on a case by case bases basis.───學(xué)校司法委員會(huì)將根據(jù)具體情況做出處罰決定.

7、The application will be evaluated on a case - by - case basis.───大會(huì)將依個(gè)別情況來(lái)決定申請(qǐng)的結(jié)果.

8、Though case - by - case solutions may emerge , the underlying tension between openness and protectionism will endure.───雖然個(gè)案的問(wèn)題可能解決, 可開(kāi)放與保護(hù)主義的潛在緊張關(guān)系會(huì)持續(xù)下去的.

9、The answer must be determined on a case - by - case basis.───答案一定要在一種個(gè)案基礎(chǔ)上被決定.

10、The University Judicial Committee judicial committee decides punishment on a case by case bases basis.───大學(xué)審判委員會(huì)根據(jù)違法行為中的基本情況來(lái)作出懲罰.

11、Bonus: based on the contribution. Case by case.───獎(jiǎng)金：按照情況分配。

12、This paper focus on the introduction of the causes of the flameproof surface damaged and how to repair them case by case.───文章主要介紹了引起防爆面損傷的原因及修復(fù)辦法。

13、Sophia : It really is case by case.───Sophia:這是看情況吧.

14、The University Judicial judicial committee decides punishment on a case by case basis.───校司法協(xié)會(huì)會(huì)根據(jù)案情的輕重來(lái)判定如何處罰.

15、You can override content settings on a case - by - case basis.───也可以根據(jù)情況忽略?xún)?nèi)容設(shè)置.

16、Each application will be assessed on a case - by - case basis.───貸款申請(qǐng)將會(huì)按個(gè)別情況審批.

17、The university dridition ? commit ? judicial committee decides punishment on a case by case bases basis.───大學(xué)的審判委員會(huì)根據(jù)不同的案子來(lái)決定懲罰情況.

case by case相似詞語(yǔ)短語(yǔ)

1、case-by-case───具體問(wèn)題具體分析；就事論事

2、pastry case───糕點(diǎn)盒

3、casease───n.分解干酪素和蛋白質(zhì)的酵素；酪蛋白酶

4、basket case───四肢不全的人；完全傷殘者；完全沒(méi)有希望的人

5、display case───展示柜

6、day case───日案件

7、classic case───經(jīng)典事例；典范案例

2、union后 order by case

order by只能用于外部查詢(xún)中，不能應(yīng)用于子查詢(xún)中。

上面的sql，union all合并了2個(gè)sql查詢(xún)結(jié)果集，order by當(dāng)成union all合并結(jié)果集的排序，但是結(jié)果集中無(wú)表a和字段bqdm。

select * from (select a.bqdm,sum(a.zyrs) 今日在院人數(shù) from YZCX_YZRB_ZY0 a ,ZY_BQDMK b

where a.bqdm=b.id

group by a.bqdm

union all

select '合計(jì)',sum(a.zyrs) from YZCX_YZRB_ZY0 a,ZY_BQDMK b where a.bqdm=b.id) a

order by

(case a.bqdm

when '8001' then 1

else 10

end)