Go4Expert - View Single Post

prabhat1

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..........

prabhat1 Go4Expert Member
9Apr2008,22:09
	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..........