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:
- Android Emulator cannot be opened because the developer cannot be verified. [M1 Mac] - Android
- Screen Mirroring iPhone to TV - iOS
- MySQL: How to Select Database via Terminal/Command Line - MySQL
- How to see storage usage details on OneDrive on Mac? - Windows
- How to install pip on macOS using terminal command [Python] - Python
- 3 Ways to Change Default 8080 Port in Spring Boot - Java
- How to Recover Deleted Messages on iPhone - iOS
- How to check your IP using bash for Windows? - Bash