CSV SQL Online

5 Columns, 10 Rows
2 Columns, 6 Rows
product_idtotal_quantity_sold
15015
25023
35033
45043
55051
65064

Also check out ✨

Check out some other tools that you might find useful

Markdown Table Formatter

Format markdown tables online. Format your messy Markdown tables into a clean and readable format.

CSV to Markdown Table

Convert CSV to Markdown Table online. This tool allows you to convert CSV to Markdown Table for free.

SQL Formatter

SQL Formatter is a free online tool to beautify, format, prettify, or minify SQL queries.

JSON Formatter

JSON Formatter is a free online tool to beautify, format, or minify JSON data.

Code Diff

Use our online code diff tool to easily compare two code snippets. Instantly highlight the differences for efficient code review and debugging. Try it now

HTML Viewer

HTML Viewer Online - Run HTML code online and see the output in real-time. This tool allows you to run HTML code online.

Markdown to HTML

Convert markdown to HTML online. This tool allows you to convert markdown to HTML code for free.

Markdown Editor

Markdown editor online. Write markdown and preview it in real-time. Markdown writer with export options and download. Supports GitHub flavored markdown.

Django Secret Key Generator

Generate Django secret key online. This tool generates a random Django secret key that you can use in your Django projects.

UUID V4 Generator

Generate version 4 UUIDs online. Supports bulk generation of UUIDs. Version 4 UUIDs are generated based on random numbers.

UUID V1 Generator

Generate version 1 UUIDs online. Supports bulk generation of UUIDs. Version 1 UUIDs are generated based on the current time and the MAC address of the computer.

JSON Editor

A minimalist JSON editor that allows you to format, validate, and edit JSON online. We never store your JSON data.

CSV Compare Online

Compare two CSV files online and see the differences between them.

If you found this tool helpful, consider buying us a coffee ☕️

How to Use the CSV SQL

Step 1 : Paste or type your CSV data in the input box. At left side you will see total columns and rows parsed.

Step 2 : Specify the separator used in the csv.

Step 3 : Design your SQL query to get the desired output, follow RBQL syntax for the query. Use javascript functions instead of sql functions.

Step 4 : Click on the Execute button, if any error in the query it will be shown in below of Execute button.

FAQs

What is CSV SQL?

CSV SQL is a tool that helps you to query CSV data using SQL queries. You can use select, filter, sort, group, distinct, javascript function, and many more in your SQL query. Also allow you to update the data in the CSV.

Supported features

  • SELECT
  • UPDATE
  • WHERE
  • ORDER BY [ DESC | ASC ]
  • GROUP BY
  • DISTINCT
  • GROUP BY
  • TOP N
  • LIMIT N
  • AS
  • JavaScript functions

Examples

UPDATE SET price = price * 1.1 WHERE price > 100
SELECT name.toLocaleLowerCase(), address.split(",")[0] AS city
SELECT MIN(parseInt(price)) AS min_price, MAX(parseInt(price)) AS max_price
SELECT * ORDER BY price, date DESC
SELECT * WHERE price > 100
SELECT sum(ammount) GROUP BY product_id