{"id":8792,"date":"2024-03-14T08:40:28","date_gmt":"2024-03-14T08:40:28","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/"},"modified":"2025-08-03T09:42:09","modified_gmt":"2025-08-03T09:42:09","slug":"how-can-multiple-data-records-be-combined-into-one-in-sql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/","title":{"rendered":"Combine Records in SQL: GROUP BY &#038; Aggregate"},"content":{"rendered":"<p>In SQL, aggregate functions and the GROUP BY statement can be used to consolidate multiple rows of data into one.<\/p>\n<p>For instance, suppose there is a table containing students&#8217; grades information, with each student possibly having multiple grade records. If we want to merge all grades for each student into one record, we can use the following SQL statement:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> student_id, <span class=\"hljs-built_in\">MAX<\/span>(grade) <span class=\"hljs-keyword\">AS<\/span> max_grade, <span class=\"hljs-built_in\">MIN<\/span>(grade) <span class=\"hljs-keyword\">AS<\/span> min_grade, <span class=\"hljs-built_in\">AVG<\/span>(grade) <span class=\"hljs-keyword\">AS<\/span> avg_grade\r\n<span class=\"hljs-keyword\">FROM<\/span> grades\r\n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> student_id;\r\n<\/code><\/pre>\n<p>In this example, we utilized the MAX, MIN, and AVG aggregation functions to calculate the highest score, lowest score, and average score for each student. We then grouped the data by student ID using the GROUP BY statement, ultimately consolidating multiple grade records into a single record.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In SQL, aggregate functions and the GROUP BY statement can be used to consolidate multiple rows of data into one. For instance, suppose there is a table containing students&#8217; grades information, with each student possibly having multiple grade records. If we want to merge all grades for each student into one record, we can use [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[408,3867,871,298,125],"class_list":["post-8792","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-aggregate-functions","tag-data-consolidation","tag-group-by","tag-mysql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Combine Records in SQL: GROUP BY &amp; Aggregate - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to merge multiple SQL records into one using GROUP BY and aggregate functions with practical examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Combine Records in SQL: GROUP BY &amp; Aggregate\" \/>\n<meta property=\"og:description\" content=\"Learn how to merge multiple SQL records into one using GROUP BY and aggregate functions with practical examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T08:40:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T09:42:09+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"Combine Records in SQL: GROUP BY &#038; Aggregate\",\"datePublished\":\"2024-03-14T08:40:28+00:00\",\"dateModified\":\"2025-08-03T09:42:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/\"},\"wordCount\":113,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"aggregate functions\",\"data consolidation\",\"GROUP BY\",\"MySQL\",\"SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/\",\"name\":\"Combine Records in SQL: GROUP BY & Aggregate - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T08:40:28+00:00\",\"dateModified\":\"2025-08-03T09:42:09+00:00\",\"description\":\"Learn how to merge multiple SQL records into one using GROUP BY and aggregate functions with practical examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Combine Records in SQL: GROUP BY &#038; Aggregate\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Combine Records in SQL: GROUP BY & Aggregate - Blog - Silicon Cloud","description":"Learn how to merge multiple SQL records into one using GROUP BY and aggregate functions with practical examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"Combine Records in SQL: GROUP BY & Aggregate","og_description":"Learn how to merge multiple SQL records into one using GROUP BY and aggregate functions with practical examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T08:40:28+00:00","article_modified_time":"2025-08-03T09:42:09+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"Combine Records in SQL: GROUP BY &#038; Aggregate","datePublished":"2024-03-14T08:40:28+00:00","dateModified":"2025-08-03T09:42:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/"},"wordCount":113,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["aggregate functions","data consolidation","GROUP BY","MySQL","SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/","name":"Combine Records in SQL: GROUP BY & Aggregate - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T08:40:28+00:00","dateModified":"2025-08-03T09:42:09+00:00","description":"Learn how to merge multiple SQL records into one using GROUP BY and aggregate functions with practical examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-records-be-combined-into-one-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Combine Records in SQL: GROUP BY &#038; Aggregate"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8792","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=8792"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8792\/revisions"}],"predecessor-version":[{"id":153618,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8792\/revisions\/153618"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=8792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=8792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=8792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}