Explore tweets tagged as #SubQuery
💡 CTE vs. Subquery: When to Use a CTE ✅ You want your query to be readable and organized: You write queries for yourself, your future self, and others, so the goal should be to make the query easy to understand and follow. ✅ You need to reuse a subquery multiple times in
10
50
356
- كفاية subquery - اخر واحدة والله - كفاية subquery - اخر واحدة والله
0
0
47
🔴When to use a Subquery Instead of a CTE 1. Table Updates: If you are updating a table, then you can use a subquery, e.g., using a correlated subquery. 2. Calculating a Scalar value: When you need to add a single, aggregated value from another table as a new column for every
2
33
239
Walked into the office and found the Elf on the Shelf deep into our website. I think he's trying to figure out how to index Santa's naughty/nice list.
0
2
5
🚨 Stop losing time to data lag! Traceye by @0xZeeve delivers subgraph & SubQuery indexing at 5X speed, with zero maintenance & full reliability. Builders, your next project deserves this → https://t.co/pGKM3ZyObX
0
0
2
Lateral joins are great for finding top-n across multiple tables. A LATERAL JOIN allows a subquery placed in the FROM clause to reference columns from the table that precedes it. - Standard join treats the joined tables and subqueries as independent sets. A standard subquery
0
5
41
Day 9 of my SQL Journey 💻 Hi #datafam, so today I decided to face my subquery fear and I started getting the hang of it. Subquery makes breaking down complex queries less scary What’s your favorite SQL trick for handling tricky queries? #30DaysOfSQL #Buildinginpublic
0
0
4
Day 5 of learning SQL using mySQL workbench •Learnt about INDEXES & different types of indexes •Learnt about SUBQUERY •Learnt about GROUP BY Clause •Learnt about the ROLLUP Clause which is an extension of GROUP BY •Learnt about the ON DELETE SET NULL & CASCADE clause
Day 4 of learning SQL using mySQL workbench •Learnt about WILD CARDS, like % & _ •Learnt about ORDER BY & LIMIT CLAUSE •Learnt about UNION •Learnt about SELF JOINS •Learnt about VIEWS
0
0
14
🏆 SQL Deep Dive: LeetCode Problem - 176. Second Highest Salary Level - Medium Concept covered - Subquery If you found this post helpful, pls like, comment and follow for more Data Science content🚀🚀
0
0
0
Umabot na sa 300 networks ang Subquery!👏🏼 Mula sa earliest parachains hanggang sa latest L2s, 300 iba’t ibang ecosystem na ngayon ang pwedeng umasa sa amin para sa data indexing. Handa na Ang networks. Handa na ang tools. Ngayon, turn naman ng mga builders.🚀 @OntologyNetwork
0
0
1
페라리 대박으로 가주아 먹여줘 @ferra_protocol 장점 요약 1) 초고속 온체인 인덱싱 — 기존 인덱서 대비 획기적으로 빠름 Ferra의 가장 큰 장점은 온체인 데이터를 실시간에 가깝게 처리한다는 것. 기존 인덱서(Graph, SubQuery 등)는 블록 인덱싱 속도가 느리거나 지연이 발생할 수 있는데,
15
0
16
Day 8 of my 30-Day SQL Today was all about Subqueries. Queries inside queries that help you break complex problems. I practiced finding: 🔹 Employees earning above the average salary 🔹 Total salary for each department Have you used subquery before? #LearnInPublic
#SQL
0
0
3
Set up dedicated Graph & SubQuery nodes for your AppChains & Rollups in just minutes with Traceye. Deploy enterprise-grade indexing infra, high availability, real-time monitoring, and zero-cost APIs. 👉 https://t.co/r1Nrb2HBNr Thread 🧵
1
0
0
CTE vs Subquery Same output Different logic But in the case, CTE is a temporary result/Table that can be reuse while nested query can't be used again. #SQL
One of the way to deal with newbie in SQL is introduced him to Sub-queries and hide CTE from him/her cuz they won't come to taste of Subquery again if CTE is revealed😂 CTE gives us 3 R's: Readability Readability Reduce complexity. This alone save us headache of nested query
0
1
1
CTE >>>>>> SUBQUERY The Manager asked me to carry out this task: " I want to see offices where the sales target for the office exceeds the sum of the individual salespeople's quotas" Different approach, same output Either SUBQUERY or CTE, gotcha! #SQL
0
0
0