---
title: 'Multiple Columns with the Same Name'
url: 'https://manuals.remository.com/plotalot/sql-for-plotalot/multiple-columns-with-the-same-name'
markdown: 'https://manuals.remository.com/plotalot/sql-for-plotalot/multiple-columns-with-the-same-name.md'
date: '2026-10-06'
description: "Some SQL tools allow you to work with queries like this: SELECT 'data_1' AS `column_1`, 'data_2' AS `column_1`; This won't work in Plotalot. All columns must have unique names. In Plotalot, if two or more columns of a SQL result have the same name, the last column takes precedence and overwrites da…"
taxonomy:
  category:
    - docs
---

[](#) [ edit this page](https://github.com/getgrav/grav-skeleton-rtfm-site/blob/develop/pages/05.sql-for-plotalot/02.multiple-columns-with-the-same-name/docs.md) 

  [ Plotalot for Joomla ](https://manuals.remository.com/plotalot/)     [ SQL for Plotalot ](https://manuals.remository.com/plotalot/sql-for-plotalot)      Multiple Columns with the Same Name    

# Multiple Columns with the Same Name

Some SQL tools allow you to work with queries like this:

```
SELECT 'data_1' AS `column_1`, 'data_2' AS `column_1`;
```

This won't work in Plotalot. All columns must have unique names. In Plotalot, if two or more columns of a SQL result have the same name, the last column takes precedence and overwrites data from a previous column with the same name.

 [ ](https://manuals.remository.com/plotalot/sql-for-plotalot/database-table-prefixes) [](https://manuals.remository.com/plotalot/sql-for-plotalot/unions-in-the-sample-charts)

---

## Navigation

- Parent: [SQL for Plotalot](https://manuals.remository.com/plotalot/sql-for-plotalot.md)
- Previous: [Database Table Prefixes](https://manuals.remository.com/plotalot/sql-for-plotalot/database-table-prefixes.md)
- Next: [Unions in the Sample Charts](https://manuals.remository.com/plotalot/sql-for-plotalot/unions-in-the-sample-charts.md)