4 ms·
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?
by atwebb 8y ago
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?
- MarkusWinand 8y agoIn principle yes, it is even mentioned in footnotes of the matrix (2, 3).
- taspeotis 8y agoThank 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-order-by-clause-transact-sql?view=sql-server-2017#b-specifying-variables-for-offset-and-fetch-values https://docs.microsoft.com/en-us/sql/t-sql/queries/select-or...
- MarkusWinand 8y agoVery 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.
- boshomi 8y ago@MarkusWindand: Thank you for the Websites [1],[2],[3] and the book »SQL Performance Explained«[4]. [1] https://modern-sql.com/ https://modern-sql.com/ [2] https://use-the-index-luke.com/ https://use-the-index-luke.com/ [3] https://db-engines.com/ https://db-engines.com/ [4] https://www.amazon.de/SQL-Performance-Explained-Everything-performance/dp/3950307826/ https://www.amazon.de/SQL-Performance-Explained-Everything-p...
- MarkusWinand 8y agoWelcome. But db-engines.com is not my site (but also run by Austrians ;)