<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=4907356971211246752&zx=c9a66ea7-fb98-42de-ba02-fec79102627b' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=4907356971211246752&zx=c9a66ea7-fb98-42de-ba02-fec79102627b' 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/1807328581-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY4BRAhIVWHw7ef5JWUT9BeTgDyyHw:1714061678367';_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': 'Blogging 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\x22Blogging 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\x22Blogging 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\x22Blogging 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\x22Blogging 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/111cb1309c0430aa', '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': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', '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': 'Blogging 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': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML14'}, {'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': 'Oppenheimer Triumphs at 96th Academy Awards', 'id': 9092177606262715736}, {'title': 'NEW Call of Duty: Mobile logo on the Google Play Store', 'id': 7215346983693666646}, {'title': 'How Do You Feel About Insomniac\x27s Multiplayer Spider-Man Game Being Cancelled?', 'id': 5226848282586193183}, {'title': 'New \u2018Super Mario Bros 2\u2019 Movie is in the Works ', 'id': 7738919599377037741}, {'title': 'Sophie Turner in Suit: Beautiful Pics', 'id': 6848159981572591824}, {'title': 'The First Critic Reactions to X-Men 97 Are Positive', 'id': 174387084465668851}, {'title': 'Marvel Studios Retitles Avengers 5 Amidst Multiverse Speculation', 'id': 4843560407491712167}]}, {'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/1666805145-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML15', 'ads-post', document.getElementById('HTML15'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML14', 'ads-post', document.getElementById('HTML14'), {}, '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>