ottomatic Posted October 13, 2005 Share Posted October 13, 2005 I know that you can do a LIMIT in mysql statements but you can't do that in MS SQL. Does anyone know an alternative to the LIMIT command in MS SQL? Link to comment https://forums.phpfreaks.com/topic/2656-ms-sql-query/ Share on other sites More sharing options...
Barand Posted October 23, 2005 Share Posted October 23, 2005 SELECT TOP 10 * FROM tablename Link to comment https://forums.phpfreaks.com/topic/2656-ms-sql-query/#findComment-9059 Share on other sites More sharing options...
Munchen Posted November 21, 2005 Share Posted November 21, 2005 Take a look at [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=76155\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?showtopic=76155[/a] how I did it. Link to comment https://forums.phpfreaks.com/topic/2656-ms-sql-query/#findComment-9758 Share on other sites More sharing options...
raul Posted February 24, 2006 Share Posted February 24, 2006 [!--quoteo(post=306053:date=Oct 13 2005, 05:20 PM:name=ottomatic)--][div class=\'quotetop\']QUOTE(ottomatic @ Oct 13 2005, 05:20 PM) 306053[/snapback][/div][div class=\'quotemain\'][!--quotec--] I know that you can do a LIMIT in mysql statements but you can't do that in MS SQL. Does anyone know an alternative to the LIMIT command in MS SQL? U could take a look at [a href=\"http://ionescuraul.users.phpclasses.org/browse/package/2832.html\" target=\"_blank\"]http://ionescuraul.users.phpclasses.org/br...ckage/2832.html[/a] Link to comment https://forums.phpfreaks.com/topic/2656-ms-sql-query/#findComment-12334 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.