b3wk Posted January 2, 2010 Share Posted January 2, 2010 Hello! I have one problem. On MySQL database I have table with name 'visitors' and there I have two column... ID Visitors 1 5690 2 5434 3 234 ... ... x 45455 y 45858 How can I sum last two rows (x + y)? I use $izbira = "SELECT SUM(visitors) FROM visitors ORDER BY id DESC LIMIT 2; but this function sum all rows... Thank you for help! ...and sorry 4 my english Quote Link to comment https://forums.phpfreaks.com/topic/186930-mysql-sum/ Share on other sites More sharing options...
Mchl Posted January 2, 2010 Share Posted January 2, 2010 SELECT SUM(sq.visitors) AS sumVisitors FROM (SELECT visitors FROM visitors ORDER BY id DESC LIMIT 2) AS sq; Quote Link to comment https://forums.phpfreaks.com/topic/186930-mysql-sum/#findComment-987112 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.