This post originated from an RSS feed registered with Java Buzz by justin cater. Original Post: SQL Server Trick: Circumvent Missing ORDER BY Clause Feed Title: Java Code Geeks Feed URL: http://feeds.feedburner.com/JavaCodeGeeks Feed Description: Java 2 Java Developers Resource Center Latest Java Buzz Posts Latest Java Buzz Posts by justin cater Latest Posts From Java Code Geeks

SQL Server is known to have a very strict interpretation of the SQL standard. For instance, the following expressions or statements are not possible in SQL Server:                   — Get arbitrarily numbered row_numbers SELECT ROW_NUMBER() OVER () — Skip arbitrary rows SELECT a FROM (VALUES (1), (2), […]