Hacker News Reader

Just skimming through but on down, is the

fetch first...with ties in Oracle

not the same as

select top (1) with ties from order by SortOrder in SQL Server?

In principle yes, it is even mentioned in footnotes of the matrix (2, 3).

Thank you for compiling the matrices. I think "Parameters in Fetch First|Next" is wrong with regards to SQL Server, it supports "Parameters (?) in fetch first" [1].

[1] https://docs.microsoft.com/en-us/sql/t-sql/queries/select-or...

Very well spotted! I've just fixed that.

One of my test cases was binding that paramter as 'numeric' rather than 'interger'. The other DBs didn't care about that.

@MarkusWindand: Thank you for the Websites [1],[2],[3] and the book »SQL Performance Explained«[4].

[1] https://modern-sql.com/

[2] https://use-the-index-luke.com/

[3] https://db-engines.com/

[4] https://www.amazon.de/SQL-Performance-Explained-Everything-p...

Welcome. But db-engines.com is not my site (but also run by Austrians ;)

Reply on news.ycombinator.com