hiiiiiiii.......... i want to use limit in my query to show only few items from database. For example i have ..10 values in my table but at a time i want to retrieve only 5 at a time The LIMIT works well in My SQL but not in SQL server please gve me the sample query....... thanks in advance.......... prabhat..........
You can use TOP to get the required number of records from the starting position in the result set, but there is no direct way to get records from a specific position as we have with LIMIT.