How to display top 40 rows? In MySql, top 40 rows are displayed by using this following query: SELECT * FROM LIMIT 0,50 Share :Click to print (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Pocket (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Facebook (Opens in new window)