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 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; Link to comment https://forums.phpfreaks.com/topic/186930-mysql-sum/#findComment-987112 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.