The SQL generated will vary depending on the provider but for Jet and SQL Server, it generates a 'TOP X' clause after the Select statement.