Clarify SQL ORDER BY and DISTINCT processing nuances

[Gulshan028]

User description

Clarified the explanation of SQL processing order for SELECT, WHERE, and ORDER BY clauses, emphasizing the role of DISTINCT. Added detailed examples to illustrate the differences in behavior with and without DISTINCT in SQL queries.

---

CodeAnt-AI Description

Clarify how ORDER BY runs relative to SELECT and DISTINCT in SQL notes

What Changed

• Replaced the previous ORDER BY explanation with a corrected logical order that keeps all columns available for sorting until after the final projection unless DISTINCT removes them early
• Added step-by-step tables showing how hidden columns persist through ORDER BY without DISTINCT and are dropped when DISTINCT runs first
• Explained why sorting by non-selected columns works without DISTINCT but fails when DISTINCT forces early projection

Impact

✅ Clearer DISTINCT ordering guidance ✅ Fewer misconceptions on ORDER BY with hidden columns ✅ More accurate SQL learning notes

💡 Usage Guide

Checking Your Pull Request

Every time you make a pull request, our system automatically looks through it. We check for security issues, mistakes in how you're setting up your infrastructure, and common code problems. We do this to make sure your changes are solid and won't cause any trouble later.

Talking to CodeAnt AI

Got a question or need a hand with something in your pull request? You can easily get in touch with CodeAnt AI right here. Just type the following in a comment on your pull request, and replace "Your question here" with whatever you want to ask:

@codeant-ai ask: Your question here

This lets you have a chat with CodeAnt AI about your pull request, making it easier to understand and improve your code.

Example

@codeant-ai ask: Can you suggest a safer alternative to storing this secret?

Preserve Org Learnings with CodeAnt

You can record team preferences so CodeAnt AI applies them in future reviews. Reply directly to the specific CodeAnt AI suggestion (in the same thread) and replace "Your feedback here" with your input:

@codeant-ai: Your feedback here

This helps CodeAnt AI learn and adapt to your team's coding style and standards.

Example

@codeant-ai: Do not flag unused imports.

Retrigger review

Ask CodeAnt AI to review the PR again, by typing:

@codeant-ai: review

Check Your Repository Health

To analyze the health of your code repository, visit our dashboard at https://app.codeant.ai. This tool helps you identify potential issues and areas for improvement in your codebase, ensuring your repository maintains high standards of code health.