華閱文章網sql中with as的用法
如下：
[TEST@ORA1] SQL>with cr as(
2 select * from tab)
3 select * from cr;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
A TABLE
TEST TABLE
詳細的說明請參照：
http://**wudataoge/blog/static/80073886200961652022389/
---
以上，希望對你有所幫助。
as和with的區別和用法
Jack as well as/ with/ along with/ together with his parents + is going to travel soon.
= 俗稱“就遠原則”
Jack's parents as well as/ with/ along with/ together with him(Jack) + are going to。.
Jack and his parents + are going。
= Jack's parents and Jack + are going 。. A and B。. 永遠是“復數”+ 復數謂語動詞。
這四句話的內容或意思是一樣的，只是表達方式略有不同。
請采納。
結合句子分析with的用法
with[wIT] prep.1.與…（在）一起，帶著：Come with me.跟我一起來吧./ I went on holiday with my friend.我跟我朋友一起去度假./ Do you want to walk home with me？你愿意和我一道走回家嗎 2.（表帶有或擁有）有…的，持有，隨身帶著：I have no money with me.我沒有帶錢./ He is a man with a hot temper.他是一個脾氣暴躁的人./ We bought a house with a garden.我們買了一座帶花園的房子./ China is a very large country with a long history.中國是一個具有歷史悠久的大國.3.（表方式、手段或工具）以，用：He caught the ball with his left hand.他用左手接球./ She wrote the letter with a pencil.她用鉛筆寫那封信.4.（表材料或內容）以，用：Fill the glass with wine.把杯子裝滿酒./ The road is paved with stones.這條路用石頭鋪砌.5.（表狀態）在…的情況下，…地：He can read French with ease.他能輕易地讀法文./ I finished my homework though with difficulty.雖然有困難，我還是做完了功課.6.（表讓步）盡管，雖然：With all his money,he is unhappy.盡管他有錢，他并不快樂./ With all his efforts,he lost the match.雖然盡了全力，他還是輸了那場比賽.7.（表條件）若是，如果：With your permission,I'll go.如蒙你同意我就去.8.（表原因或理由）因為，由于：He is tired with work.他工作做累了./ At the news we all jumped with joy.聽到這消息我們都高興得跳了起來.9.（表時間）當…的時候，在…之后：With that remark,he left.他說了那話就離開了./ With daylight I hurried there to see what had happened.天一亮我就去那兒看發生了什么事.10.（表同時或隨同）與…一起，隨著：The girl seemed to be growing prettier with each day.那女孩好像長得一天比一天漂亮.11.（表伴隨或附帶情況）同時：I slept with the window open.我開著窗戶睡覺./ Don't speak with your mouth full.不要滿嘴巴食物說話.12.贊成，同意：I am with you there.在那點上我同你意見一致.13.由…照看，交…管理，把…放在某處：I left a message for you with your secretary.我給你留了個信兒交給你的秘書了./ The keys are with reception.鑰匙放在接待處.14 （表連同或包含）連用，包含：The meal with wine came to ￡8 each.那頓飯連酒每人8英鎊./ With preparation and marking a teacher works 12 hours a day.一位老師連備課帶批改作業每天工作12小時.15.（表對象或關系）對，關于，就…而言，對…來說：He is pleased with his new house.他對他的新房子很滿意./ The teacher was very angry with him.老師對他很生氣./ It's the same with us students.我們學生也是這樣.16.（表對立或敵對）跟，以…為對手：The dog was fighting with the cat.狗在同貓打架./ He's always arguing with his brother.他老是跟他弟弟爭論.17.（在祈使句中與副詞連用）：Away with him！帶他走！/ Off with your clothes！脫掉衣服！/ Down with your money！交出錢來！【用法】1.表示方式、手段或工具等時（=以，用），注意不要受漢語意思的影響而用錯搭配，如“用英語”習慣上用in English，而不是with English.2.與某些抽象名詞連用時，其作用相當于一個副詞：with care=carefully 認真地 / with kindness=kindly 親切地 / with joy=joyfully 高興地 / with anger=angrily 生氣地 / with sorrow=sorrowfully 悲傷地 / with ease=easily 容易地 / with delight=delightedly 高興地 / with great fluency =very fluently 很流利地 3.表示條件時，根據情況可與虛擬語氣連用：With more money I would be able to buy it.要是錢多一點，我就買得起了./ With better equipment,we could have finished the job even sooner.要是設備好些，我們完成這項工作還要快些.4.比較with和as：兩者均可表示“隨著”，但前者是介詞，后者是連詞：He will improve as he grows older.隨著年齡的增長，他會進步的./ People's ideas change with the change of the times.時代變了，人們的觀念也會變化.5.介詞with和to均可表示“對”，但各自的搭配不同，注意不要受漢語意思的影響而用錯，如在kind,polite,rude,good,married等形容詞后通常不接介詞with而接to.6.復合結構“with+賓語+賓語補足語”是一個很有用的結構，它在句中主要用作狀語，表示伴隨、原因、時間、條件、方式等；其中的賓語補足語可以是名詞、形容詞、副詞、現在分詞、過去分詞、不定式、介詞短語等：I went out with the windows open.我外出時沒有關窗戶./ He stood before his teacher with his head down.他低著頭站在老師面前./ He was lying on the bed with all his clothes on.他和衣躺在床上./ He died with his daughter yet a schoolgirl.他去世時，女兒還是個小學生./ The old man sat there with a basket beside her.老人坐在那兒，身邊放著一個籃子./ He fell asleep with the lamp burning.他沒熄燈就睡著了./ He sat there with his eyes closed.他閉目坐在那兒./ I can't go out with all these clothes to wash.要洗這些衣服，我無法出去了.這類結構也常用于名詞后作定語：The boy with nothing on is her son.沒穿衣服的這個男孩子是她兒子.（摘自《英語常用詞多用途詞典》金盾出版社）。
轉載請注明出處華閱文章網 » withas語句的用法
