The "ORDER BY" clause behavior

Question

Post reply

The "ORDER BY" clause behavior

Alessandro Mortola

SSC Eights!

Points: 904
More actions
May 8, 2024 at 12:00 am

#4399706

Comments posted to this topic are about the item The "ORDER BY" clause behavior

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 1

Nice question, Alessandro. Proof, yet again, that SQL <> SQL and that the basic training out there isn't working 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

I can barely spell postgresql let alone use it. I answered with a best guess but figured there must be a difference between them. After getting it wrong and reading the documentation I have to say I really like the optional addition of NULL placement with postgresql.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

webrunner SSC-Dedicated Points: 31862 More actions · Answer 3

Thanks for this great fundamental question. I can't believe I got the SQL Server NULL sort order wrong! Time to review the basics.

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html