Jamesking56 Posted February 19, 2008 Share Posted February 19, 2008 How do I only display the top TEN records, like if i had a table with 16 records, how do I only display the top ten in a certain order? Link to comment Share on other sites More sharing options...
justsomeguy Posted February 19, 2008 Share Posted February 19, 2008 If you're using SQL Server you do this:SELECT TOP 10 * FROM ... Link to comment Share on other sites More sharing options...
Jamesking56 Posted February 19, 2008 Author Share Posted February 19, 2008 If you're using SQL Server you do this:SELECT TOP 10 * FROM ...is that really it? they dont really explain that in the tutorials...... Link to comment Share on other sites More sharing options...
justsomeguy Posted February 19, 2008 Share Posted February 19, 2008 They don't explain a lot in the tutorials. If it's MySQL then you can use LIMIT.SELECT * FROM table LIMIT 10 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.