{
  "api": "sql-keywords",
  "title": "SQL Keywords",
  "description": "Common SQL keywords and clauses grouped by language category.",
  "emoji": "🗄",
  "license": "GPL-2.0-or-later",
  "count": 36,
  "self": "https://gratisapi.com/api/sql-keywords/index",
  "endpoints": {
    "list": "https://gratisapi.com/api/sql-keywords/index",
    "item": "https://gratisapi.com/api/sql-keywords/{id}"
  },
  "fields": [
    "category",
    "description",
    "id",
    "keyword"
  ],
  "results": [
    {
      "id": "select",
      "keyword": "SELECT",
      "category": "DQL",
      "description": "Retrieves rows and columns from one or more tables.",
      "url": "https://gratisapi.com/api/sql-keywords/select"
    },
    {
      "id": "from",
      "keyword": "FROM",
      "category": "Clause",
      "description": "Specifies the table or tables from which to retrieve data.",
      "url": "https://gratisapi.com/api/sql-keywords/from"
    },
    {
      "id": "where",
      "keyword": "WHERE",
      "category": "Clause",
      "description": "Filters rows based on a specified condition.",
      "url": "https://gratisapi.com/api/sql-keywords/where"
    },
    {
      "id": "group-by",
      "keyword": "GROUP BY",
      "category": "Clause",
      "description": "Groups rows that share values so aggregate functions apply per group.",
      "url": "https://gratisapi.com/api/sql-keywords/group-by"
    },
    {
      "id": "having",
      "keyword": "HAVING",
      "category": "Clause",
      "description": "Filters groups produced by GROUP BY based on a condition.",
      "url": "https://gratisapi.com/api/sql-keywords/having"
    },
    {
      "id": "order-by",
      "keyword": "ORDER BY",
      "category": "Clause",
      "description": "Sorts the result set by one or more columns.",
      "url": "https://gratisapi.com/api/sql-keywords/order-by"
    },
    {
      "id": "limit",
      "keyword": "LIMIT",
      "category": "Clause",
      "description": "Restricts the number of rows returned by a query.",
      "url": "https://gratisapi.com/api/sql-keywords/limit"
    },
    {
      "id": "distinct",
      "keyword": "DISTINCT",
      "category": "Clause",
      "description": "Removes duplicate rows from the result set.",
      "url": "https://gratisapi.com/api/sql-keywords/distinct"
    },
    {
      "id": "join",
      "keyword": "JOIN",
      "category": "Clause",
      "description": "Combines rows from two or more tables based on a related column.",
      "url": "https://gratisapi.com/api/sql-keywords/join"
    },
    {
      "id": "inner-join",
      "keyword": "INNER JOIN",
      "category": "Clause",
      "description": "Returns only rows with matching values in both joined tables.",
      "url": "https://gratisapi.com/api/sql-keywords/inner-join"
    },
    {
      "id": "left-join",
      "keyword": "LEFT JOIN",
      "category": "Clause",
      "description": "Returns all rows from the left table and matched rows from the right.",
      "url": "https://gratisapi.com/api/sql-keywords/left-join"
    },
    {
      "id": "union",
      "keyword": "UNION",
      "category": "Operator",
      "description": "Combines the result sets of two queries, removing duplicates.",
      "url": "https://gratisapi.com/api/sql-keywords/union"
    },
    {
      "id": "as",
      "keyword": "AS",
      "category": "Clause",
      "description": "Assigns an alias to a column or table.",
      "url": "https://gratisapi.com/api/sql-keywords/as"
    },
    {
      "id": "on",
      "keyword": "ON",
      "category": "Clause",
      "description": "Specifies the condition used to join tables.",
      "url": "https://gratisapi.com/api/sql-keywords/on"
    },
    {
      "id": "insert",
      "keyword": "INSERT",
      "category": "DML",
      "description": "Adds one or more new rows into a table.",
      "url": "https://gratisapi.com/api/sql-keywords/insert"
    },
    {
      "id": "update",
      "keyword": "UPDATE",
      "category": "DML",
      "description": "Modifies existing rows in a table.",
      "url": "https://gratisapi.com/api/sql-keywords/update"
    },
    {
      "id": "delete",
      "keyword": "DELETE",
      "category": "DML",
      "description": "Removes one or more rows from a table.",
      "url": "https://gratisapi.com/api/sql-keywords/delete"
    },
    {
      "id": "values",
      "keyword": "VALUES",
      "category": "Clause",
      "description": "Specifies the data to insert with an INSERT statement.",
      "url": "https://gratisapi.com/api/sql-keywords/values"
    },
    {
      "id": "set",
      "keyword": "SET",
      "category": "Clause",
      "description": "Specifies the columns and values to change in an UPDATE statement.",
      "url": "https://gratisapi.com/api/sql-keywords/set"
    },
    {
      "id": "create",
      "keyword": "CREATE",
      "category": "DDL",
      "description": "Creates a new database object such as a table, index, or view.",
      "url": "https://gratisapi.com/api/sql-keywords/create"
    },
    {
      "id": "alter",
      "keyword": "ALTER",
      "category": "DDL",
      "description": "Modifies the structure of an existing database object.",
      "url": "https://gratisapi.com/api/sql-keywords/alter"
    },
    {
      "id": "drop",
      "keyword": "DROP",
      "category": "DDL",
      "description": "Permanently deletes a database object such as a table or index.",
      "url": "https://gratisapi.com/api/sql-keywords/drop"
    },
    {
      "id": "truncate",
      "keyword": "TRUNCATE",
      "category": "DDL",
      "description": "Quickly removes all rows from a table without logging individual deletes.",
      "url": "https://gratisapi.com/api/sql-keywords/truncate"
    },
    {
      "id": "grant",
      "keyword": "GRANT",
      "category": "DCL",
      "description": "Gives specific privileges to a database user or role.",
      "url": "https://gratisapi.com/api/sql-keywords/grant"
    },
    {
      "id": "revoke",
      "keyword": "REVOKE",
      "category": "DCL",
      "description": "Removes previously granted privileges from a user or role.",
      "url": "https://gratisapi.com/api/sql-keywords/revoke"
    },
    {
      "id": "commit",
      "keyword": "COMMIT",
      "category": "TCL",
      "description": "Permanently saves all changes made in the current transaction.",
      "url": "https://gratisapi.com/api/sql-keywords/commit"
    },
    {
      "id": "rollback",
      "keyword": "ROLLBACK",
      "category": "TCL",
      "description": "Undoes changes made in the current transaction.",
      "url": "https://gratisapi.com/api/sql-keywords/rollback"
    },
    {
      "id": "savepoint",
      "keyword": "SAVEPOINT",
      "category": "TCL",
      "description": "Sets a point within a transaction to which you can later roll back.",
      "url": "https://gratisapi.com/api/sql-keywords/savepoint"
    },
    {
      "id": "and",
      "keyword": "AND",
      "category": "Operator",
      "description": "Combines conditions; all must be true for a row to match.",
      "url": "https://gratisapi.com/api/sql-keywords/and"
    },
    {
      "id": "or",
      "keyword": "OR",
      "category": "Operator",
      "description": "Combines conditions; at least one must be true for a row to match.",
      "url": "https://gratisapi.com/api/sql-keywords/or"
    },
    {
      "id": "not",
      "keyword": "NOT",
      "category": "Operator",
      "description": "Negates a condition.",
      "url": "https://gratisapi.com/api/sql-keywords/not"
    },
    {
      "id": "in",
      "keyword": "IN",
      "category": "Operator",
      "description": "Tests whether a value matches any value in a list or subquery.",
      "url": "https://gratisapi.com/api/sql-keywords/in"
    },
    {
      "id": "between",
      "keyword": "BETWEEN",
      "category": "Operator",
      "description": "Tests whether a value falls within an inclusive range.",
      "url": "https://gratisapi.com/api/sql-keywords/between"
    },
    {
      "id": "like",
      "keyword": "LIKE",
      "category": "Operator",
      "description": "Matches a value against a pattern using wildcards.",
      "url": "https://gratisapi.com/api/sql-keywords/like"
    },
    {
      "id": "is-null",
      "keyword": "IS NULL",
      "category": "Operator",
      "description": "Tests whether a value is NULL.",
      "url": "https://gratisapi.com/api/sql-keywords/is-null"
    },
    {
      "id": "exists",
      "keyword": "EXISTS",
      "category": "Operator",
      "description": "Tests whether a subquery returns any rows.",
      "url": "https://gratisapi.com/api/sql-keywords/exists"
    }
  ]
}