1 files changed, 7 insertions, 0 deletions
diff --git a/lib/arel/visitors/mssql.rb b/lib/arel/visitors/mssql.rb
index 9b0e77c19b..ea7ab6394c 100644
--- a/lib/arel/visitors/mssql.rb
+++ b/lib/arel/visitors/mssql.rb
@@ -3,6 +3,13 @@ module Arel
     class MSSQL < Arel::Visitors::ToSql
       private
 
+      def build_subselect key, o
+        stmt     = super
+        core     = stmt.cores.first
+        core.top = Nodes::Top.new(o.limit.expr) if o.limit
+        stmt
+      end
+
       def visit_Arel_Nodes_Limit o
         ""
       end