SELECT TOP 1 * FROM Orders
❌ Problem
Result can change between executions.
✅ Always do
ORDER BY CreatedAt DESC
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
SELECT TOP 1 * FROM Orders
Result can change between executions.
ORDER BY CreatedAt DESC