Enter Unformatted SQL Query:
Formatted SQL:
A very simple and easy-to-use SQL Queries prettifier tool. Works with all kinds of queries including.
SELECT | INSERT | UPDATE |
DELETE | CREATE | ALTER |
JOIN | HAVING | SET |
UNION | AND | OR |
ORDER BY | GROUP BY | LIMIT |
DISTINCT | CASE | WHEN |
ELSE | END | EXISTS |
NOT EXISTS | IN | NOT IN |
LIKE | NOT LIKE | BETWEEN |
NOT BETWEEN | IS NULL | IS NOT NULL |
AS | INNER JOIN | LEFT JOIN |
RIGHT JOIN | FULL OUTER JOIN | CROSS JOIN |
NATURAL JOIN | INNER JOIN ON | LEFT JOIN ON |
RIGHT JOIN ON | FULL OUTER JOIN ON | CROSS JOIN ON |
EXISTS (subquery) | NOT EXISTS (subquery) | IN (subquery) |
NOT IN (subquery) | LIKE (pattern matching) | NOT LIKE (pattern matching) |
BETWEEN (range) | NOT BETWEEN (range) | IS NULL (null check) |
IS NOT NULL (null check) | AS (aliasing) | DISTINCT (unique values) |
COUNT (aggregation) | SUM (aggregation) | AVG (aggregation) |
MAX (aggregation) | MIN (aggregation) | GROUP BY (grouping) |
HAVING (filtering aggregated results) | ORDER BY (sorting) | LIMIT (result limiting) |
OFFSET (result offset) |
Facing issues? Have Questions? Post them here! I am happy to answer!
Author Info:
Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.
Follow him on: X
You can also reach out to him via e-mail: rakesh@code2care.org
More Posts related to Tools,
- Free Online Eraser Tool for Images (PNG, JPG, JPEG and GIF)
- Online XML Code Formatter (Prettify) Tool
- Online Free SQL Query Formatter (Prettifier) Tool
- Online Morse Code To Audio Converter Tool [Free]
- Online Tool to Sort Data Alphabetical (Ascending/Descending)
- Fahrenheit to Celsius Temperature Convertor: Tool & Formula
- Text Case Converter - Convert to Upper/Lower/Proper/Random Case
- Tool: Convert Cron Expression To Plain English Text (Supports Quartz)
- Draw Anything Anywhere - Free Online Drawing Canvas
- Online JSON Validator Tool
- Online HTML Code Formatter (Prettier) Tool
- Online Free JSON String Formatter (Prettifier) Tool
More Posts:
- JUnit 4 Setup Example with IntelliJ + Maven - Java
- TextEdit save file with txt extension - MacOS
- Fix: ModuleNotFoundError: No module named pip - PIP
- 7 deadly java.lang.OutOfMemoryError in Java Programming - Java
- Remove Trailing zeros BigDecimal Java - Java
- cURL Option to show HTTP Response Status Code - cURL
- Find Hostname of Mac running on macOS Ventura 13 - MacOS
- How to upload and read csv file in Google Colab - Google