<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=4907356971211246752&zx=09245b7e-a098-458e-a93e-b521e31b8f97' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=4907356971211246752&zx=09245b7e-a098-458e-a93e-b521e31b8f97' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<!-- data-ad-client=ca-pub-1497747774874198 -->

</head><body>*/</style>

Get Sum of Column in MySQL table

Jun 6, 2016

Get sum of column in MySQL table

We have a table named "students_marks", we find out the total marks obtain by students in the table.

Now, We will use the SUM command like this -

SELECT sum( marks ) FROM `student_marks`

sum (marks)

335

get sum of column mysql

Notes :

sum two columns in mysql query

mysql sum two columns from two tables

mysql sum of two columns of a row

mysql order by sum of two columns

Tags :

sql sum, sql tutorial, sql total, column total, free tutorial, Sql sum tutorials to get total of column in mysql table, mysql, mysql sum total of a numaric field of column of a table, sum two columns in mysql query, group by two columns mysql, mysql sum two columns from two tables, how to get sum of two columns in sql, mysql sum of two columns of a row, mysql order by sum of two columns, get sum of two columns mysql

div>

Publisher - PhpWorldOnline

Author - Piyush Verma

sql. mysql Tutorial

Piyush Verma

I am a Blogger and Web Designer.

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY4p7rcFQXKndn0rnZ2Z-_c2iqLPWw:1732074013380';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d4907356971211246752','//blogging-universe.blogspot.com/2016/06/get-sum-of-column-in-mysql-table.html','4907356971211246752');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '4907356971211246752', 'title': 'Blog Universe', 'url': 'https://blogging-universe.blogspot.com/2016/06/get-sum-of-column-in-mysql-table.html', 'canonicalUrl': 'https://blogging-universe.blogspot.com/2016/06/get-sum-of-column-in-mysql-table.html', 'homepageUrl': 'https://blogging-universe.blogspot.com/', 'searchUrl': 'https://blogging-universe.blogspot.com/search', 'canonicalHomepageUrl': 'https://blogging-universe.blogspot.com/', 'blogspotFaviconUrl': 'https://blogging-universe.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Blog Universe - Atom\x22 href\x3d\x22https://blogging-universe.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Blog Universe - RSS\x22 href\x3d\x22https://blogging-universe.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Blog Universe - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/4907356971211246752/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Blog Universe - Atom\x22 href\x3d\x22https://blogging-universe.blogspot.com/feeds/9180048696762270372/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-1497747774874198', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/4ff351627da87384', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '9180048696762270372', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirRpyHd7780etFub0V9p2ljRaubxfDjGcljoshYBrFNNroFBRMcHIFEkugfn1-zoMKdD9wB6mQKGObhQTiX5bX4cx2LnEx4Jr2tkZhGFpfu5F6HRwKoZwP-of9ujFngR-6_yCns3Td6yw/s72-c/get-sum-of-two-columns-mysql.jpg', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirRpyHd7780etFub0V9p2ljRaubxfDjGcljoshYBrFNNroFBRMcHIFEkugfn1-zoMKdD9wB6mQKGObhQTiX5bX4cx2LnEx4Jr2tkZhGFpfu5F6HRwKoZwP-of9ujFngR-6_yCns3Td6yw/s1600/get-sum-of-two-columns-mysql.jpg', 'pageName': 'Get Sum of Column in MySQL table', 'pageTitle': 'Blog Universe: Get Sum of Column in MySQL table'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Get Sum of Column in MySQL table', 'description': '     Get sum of column in MySQL table   We have a table named \x22students_marks\x22, we find out the total marks obtain by students in the table....', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirRpyHd7780etFub0V9p2ljRaubxfDjGcljoshYBrFNNroFBRMcHIFEkugfn1-zoMKdD9wB6mQKGObhQTiX5bX4cx2LnEx4Jr2tkZhGFpfu5F6HRwKoZwP-of9ujFngR-6_yCns3Td6yw/s1600/get-sum-of-two-columns-mysql.jpg', 'url': 'https://blogging-universe.blogspot.com/2016/06/get-sum-of-column-in-mysql-table.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 9180048696762270372}}, {'name': 'widgets', 'data': [{'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': '#CustomPost by Label', 'type': 'HTML', 'sectionId': 'special-home', 'id': 'HTML26'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '9180048696762270372', 'title': 'Get Sum of Column in MySQL table', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirRpyHd7780etFub0V9p2ljRaubxfDjGcljoshYBrFNNroFBRMcHIFEkugfn1-zoMKdD9wB6mQKGObhQTiX5bX4cx2LnEx4Jr2tkZhGFpfu5F6HRwKoZwP-of9ujFngR-6_yCns3Td6yw/s1600/get-sum-of-two-columns-mysql.jpg', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'timestamp', 'label': 'MMM d, yyyy'}, {'name': 'share', 'label': ''}]}, 'footerBylines': [{'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Tags:'}]}], 'allBylineItems': [{'name': 'timestamp', 'label': 'MMM d, yyyy'}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': 'Tags:'}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML15'}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-sticky', 'id': 'Label11'}, {'title': 'AD', 'type': 'HTML', 'sectionId': 'sidebar-sticky', 'id': 'HTML1'}, {'title': 'Most Viewed', 'type': 'PopularPosts', 'sectionId': 'sidebar-sticky', 'id': 'PopularPosts10', 'posts': [{'title': 'Viviane Lomelin: Beautiful Girl With a Beautiful Face', 'id': 1904273912083866776}, {'title': 'John Cena CRASHES Brie Larson\x27s Interview', 'id': 1602846434023180722}, {'title': 'Why Do a Lot of Youtubers Struggle?', 'id': 8468966021657186400}, {'title': 'Mrunal Thakur: The Beauty That Captivates', 'id': 131339717168397669}, {'title': 'Trisha Krishnan Pink Saree Hot Mobile Wallpaper', 'id': 1468811444630704474}, {'title': 'Sai Pallavi in Virata Parvam : Movie Photos', 'id': 5025620377610276417}, {'title': 'Sara Tendulkar Instagram [3 Cute Photos]', 'id': 1558889107244203552}]}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList14'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML22'}, {'title': 'Partners', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList1'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML27'}, {'title': 'License Key', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML28'}]}]);
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML26', 'special-home', document.getElementById('HTML26'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2646514562-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML15', 'ads-post', document.getElementById('HTML15'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label11', 'sidebar-sticky', document.getElementById('Label11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'sidebar-sticky', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-sticky', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList14', 'footer-widget', document.getElementById('LinkList14'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML22', 'footer-widget', document.getElementById('HTML22'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList1', 'footer-widget', document.getElementById('LinkList1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML27', 'jet-options', document.getElementById('HTML27'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML28', 'jet-options', document.getElementById('HTML28'), {}, 'displayModeFull'));
</script>
</body>*/</style>