@caterine.thalia:

caterine.thalia
caterine.thalia
Open In TikTok:
Region: AR
Sunday 20 July 2025 01:28:11 GMT
589
55
1
0

Music

Download

Comments

kkkkx58
yimdes :
😍😍😍
2025-07-27 03:27:12
0
To see more videos from user @caterine.thalia, please go to the Tikwm homepage.

Other Videos

UNION apaga a linha certa do seu relatório. Você tem as vendas do site numa tabela e as da loja em outra, e quer as duas juntas num relatório só. Isso é UNION ALL: uma pilha em cima da outra, tudo fica. Aí alguém fala pra usar UNION,
UNION apaga a linha certa do seu relatório. Você tem as vendas do site numa tabela e as da loja em outra, e quer as duas juntas num relatório só. Isso é UNION ALL: uma pilha em cima da outra, tudo fica. Aí alguém fala pra usar UNION, "porque o UNION tira as duplicatas". E é exatamente nessa palavra que a coisa desanda. Olha as vendas da loja: fone, 200 reais. Fone, 200 reais de novo. Não é erro de sistema, não é linha gravada duas vezes — são duas pessoas diferentes que compraram o mesmo fone no mesmo dia. São 400 reais que entraram no caixa. Só que no seu SELECT só tem produto e valor. Sem o cliente e sem a hora, essas duas linhas são idênticas pro UNION. Ele guarda uma, joga a outra fora, e o relatório fecha com 200. Metade da venda sumiu — e não deu erro, não deu aviso, a query rodou bonitinho. E ainda tem o preço escondido: pra achar o que é repetido, o banco compara tudo com tudo. Mesmo quando não tem nada pra remover. Então inverte o padrão. UNION ALL é o normal. UNION é a exceção, pra quando você quer mesmo que linha repetida suma. 🪜 **UNION ALL empilha o que você mandou. UNION empilha o que ele achou que você quis.** ✅ Vale em: PostgreSQL, MySQL, SQL Server, Oracle, BigQuery, SQLite, DuckDB — UNION e UNION ALL são ANSI e se comportam igual em todos. ⚠️ Exceção: no MySQL e no PostgreSQL dá pra escrever UNION DISTINCT, que é a mesma coisa que UNION — só deixa explícito o que ele faz com as suas linhas. 🧭 Teste na sua versão: roda a mesma consulta com UNION ALL e com UNION e compara o COUNT(*). A diferença entre os dois números é exatamente o que o UNION apagou. 💾 Salva pra não esquecer, manda pra quem monta relatório de vendas e segue pra não perder os próximos. Qual dos dois você escreve no automático: UNION ou UNION ALL? Conta aí 👇 #negocios #dados #sql #union #aprendersql
🎁 Exclusive Offer: Buy 2 Get 1! ​(၂) လစာ ကြိုတင်ပေးသွင်းရုံဖြင့် (၁) လ အခမဲ့ အသုံးပြုခွင့်ရရှိမည့် အထူးအခွင့်အရေး။ ​✨ ဝန်ဆောင်မှု၏ အားသာချက်များ ​✅ Free Installation & Device – တပ်ဆင်ခနှင့် စက်ပစ္စည်းဖိုး (လုံးဝ) အခမဲ့။ ​✅ Fast Service – (၂၄) နာရီအတွင်း အမြန်တပ်ဆင်ပေးခြင်းနှင့် အမြန်ဆုံးပြုပြင်ထိန်းသိမ်းပေးခြင်း။ ​✅ Reliable Network – 95% Uptime အာမခံချက်နှင့် 24/7 Technical Support။ ​✅ Dedicated Account Person – လုပ်ငန်းအတွက် အနီးကပ်အကူအညီပေးမည့် ဝန်ထမ်းသီးသန့်ထားရှိပေးခြင်း။ ​💰 Monthly Price Plans ​သင့်လုပ်ငန်းနှင့် ကိုက်ညီမည့် Speed အလိုက် ဈေးနှုန်းများကို ရွေးချယ်နိုင်ပါသည်- 🔹 50 Mbps -86,250 MMK ​🔹 100 Mbps — 115,000 MMK ​🔹 200 Mbps — 172,500 MMK ​🔹 300 Mbps — 287,500 MMK ​🔹 400 Mbps — 402,500 MMK ​စာချုပ်သက်တမ်းမှာ (၆) လ ဖြစ်ပါသည်။ ​📞 အသေးစိတ် ဆက်သွယ်စုံစမ်းရန် ​လူကြီးမင်းတို့၏ လုပ်ငန်းလိုအပ်ချက်များကို ဆွေးနွေးလိုပါက အောက်ပါဖုန်းနံပါတ်သို့ ဆက်သွယ်နိုင်ပါသည်။ ​☎️ 09 961300594 ​#BusinessInternet #DIA #DedicatedInternet #HighSpeed #InternetService
🎁 Exclusive Offer: Buy 2 Get 1! ​(၂) လစာ ကြိုတင်ပေးသွင်းရုံဖြင့် (၁) လ အခမဲ့ အသုံးပြုခွင့်ရရှိမည့် အထူးအခွင့်အရေး။ ​✨ ဝန်ဆောင်မှု၏ အားသာချက်များ ​✅ Free Installation & Device – တပ်ဆင်ခနှင့် စက်ပစ္စည်းဖိုး (လုံးဝ) အခမဲ့။ ​✅ Fast Service – (၂၄) နာရီအတွင်း အမြန်တပ်ဆင်ပေးခြင်းနှင့် အမြန်ဆုံးပြုပြင်ထိန်းသိမ်းပေးခြင်း။ ​✅ Reliable Network – 95% Uptime အာမခံချက်နှင့် 24/7 Technical Support။ ​✅ Dedicated Account Person – လုပ်ငန်းအတွက် အနီးကပ်အကူအညီပေးမည့် ဝန်ထမ်းသီးသန့်ထားရှိပေးခြင်း။ ​💰 Monthly Price Plans ​သင့်လုပ်ငန်းနှင့် ကိုက်ညီမည့် Speed အလိုက် ဈေးနှုန်းများကို ရွေးချယ်နိုင်ပါသည်- 🔹 50 Mbps -86,250 MMK ​🔹 100 Mbps — 115,000 MMK ​🔹 200 Mbps — 172,500 MMK ​🔹 300 Mbps — 287,500 MMK ​🔹 400 Mbps — 402,500 MMK ​စာချုပ်သက်တမ်းမှာ (၆) လ ဖြစ်ပါသည်။ ​📞 အသေးစိတ် ဆက်သွယ်စုံစမ်းရန် ​လူကြီးမင်းတို့၏ လုပ်ငန်းလိုအပ်ချက်များကို ဆွေးနွေးလိုပါက အောက်ပါဖုန်းနံပါတ်သို့ ဆက်သွယ်နိုင်ပါသည်။ ​☎️ 09 961300594 ​#BusinessInternet #DIA #DedicatedInternet #HighSpeed #InternetService

About