Search
#純靠北工程師4z0
----------
公司一段 SQL 是這樣寫的：
select top 1 t2.xxx
from (
巴拉巴拉一大串，看到眼花
) t1
left outer join t2
on t1.xx = t2.xx
where t2.xx = XXX
所以我說，前輩中間寫那一大串是在裝忙嗎？
select top 1 t2.xx
from t2
where t2.xx = XXX
結果一模一樣 @@
最近大前輩一直抱怨公司資料庫效能太差，我彷彿知道了什麼
----------
💖 純靠北官方 Discord 歡迎在這找到你的同溫層！
👉 https://discord.gg/tPhnrs2
----------
💖 全平台留言、文章詳細內容
👉 https://init.engineer/cards/show/6444
準備 156 個流行的真實世界 SQL 面試問題，並自信地走進面試，對於你會被問的各類型問題胸有成竹。 給面試官留下深刻的印象
測驗包含以下資料庫和 SQL 主題的問題：
Databases Core Concepts
Normalization (First Normal Form, Second Normal Form, Third Normal Form)
Relationships
SQL Queries Basics
SELECT statement and syntax
SQL Data Types
WHERE operators: comparison operators, LIKE, BETWEEN, IN
Scalar Functions
Aggregate Functions (SUM, COUNT, MIN, MAX, AVG)
GROUP BY
ORDER BY
JOINS (INNER JOIN, RIGHT and LEFT JOIN, OUTER JOIN, CROSS JOIN)
Set Theory (INTERSECT, UNION, MINUS)
Subqueries
INSERT, UPDATE, DELETE
DML vs DDL vs DCL
DDL: CREATE, DROP, ALTER
Constraints
Indexes
DCL privileges: GRANT, REVOKE
Transactions
Views
Triggers
Cursors
https://softnshare.com/2018/06/09/sql-interview-questions/
