Compare text

Find the difference between two text files

Real-time editor

Hide unchanged lines

Disable line wrap

Layout

Diff precision

Syntax highlighting

Diffchecker Desktop The most secure way to run Diffchecker. Get the Diffchecker Desktop app: your diffs never leave your computer!Get Desktop

Diff in Prompt

Created 2 years agoDiff never expires

1 removal

Lines
Total
Removed

Characters
Total
Removed

To continue using this feature, upgrade to Diffchecker Pro View Pricing

20 lines

5 additions

Lines
Total
Added

Characters
Total
Added

To continue using this feature, upgrade to Diffchecker Pro View Pricing

24 lines

"Given an input question, first create a syntactically correct {dialect} "

"query to run, then look at the results of the query and return the answer. "

"You can order the results by a relevant column to return the most "

"interesting examples in the database.\n\n"

"Never query for all the columns from a specific table, only ask for a "

"few relevant columns given the question.\n\n"

"Pay attention to use only the column names that you can see in the schema "

"description. "

"Be careful to not query for columns that do not exist. "

"Pay attention to which column is in which table. "

"Also, qualify column names with the table name when needed. "

"Also, qualify column names with the table name when needed. \n"

"If needing to group on Array Columns use the ClickHouse function arrayJoin e.g. arrayJoin(columnName) \n"

"For example, the following query identifies the most popular database:\n"

"SELECT d, count(*) AS count FROM so_surveys GROUP BY "

"arrayJoin(database_want_to_work_with) AS d ORDER BY count DESC LIMIT 1\n"

"You are required to use the following format, each taking one line:\n\n"

"Question: Question here\n"

"SQLQuery: SQL Query to run\n"

"SQLResult: Result of the SQLQuery\n"

"Answer: Final answer here\n\n"

"Only use tables listed below.\n"

"{schema}\n\n"

"Question: {query_str}\n"

"SQLQuery: "

Saved diffs

Original text

Open file

"Given an input question, first create a syntactically correct {dialect} "
    "query to run, then look at the results of the query and return the answer. "
    "You can order the results by a relevant column to return the most "
    "interesting examples in the database.\n\n"
    "Never query for all the columns from a specific table, only ask for a "
    "few relevant columns given the question.\n\n"
    "Pay attention to use only the column names that you can see in the schema "
    "description. "
    "Be careful to not query for columns that do not exist. "
    "Pay attention to which column is in which table. "
    "Also, qualify column names with the table name when needed. "
    "You are required to use the following format, each taking one line:\n\n"
    "Question: Question here\n"
    "SQLQuery: SQL Query to run\n"
    "SQLResult: Result of the SQLQuery\n"
    "Answer: Final answer here\n\n"
    "Only use tables listed below.\n"
    "{schema}\n\n"
    "Question: {query_str}\n"
    "SQLQuery: "

Changed text

Open file

"Given an input question, first create a syntactically correct {dialect} "
    "query to run, then look at the results of the query and return the answer. "
    "You can order the results by a relevant column to return the most "
    "interesting examples in the database.\n\n"
    "Never query for all the columns from a specific table, only ask for a "
    "few relevant columns given the question.\n\n"
    "Pay attention to use only the column names that you can see in the schema "
    "description. "
    "Be careful to not query for columns that do not exist. "
    "Pay attention to which column is in which table. "
    "Also, qualify column names with the table name when needed. \n"
    "If needing to group on Array Columns use the ClickHouse function arrayJoin e.g. arrayJoin(columnName) \n"
    "For example, the following query identifies the most popular database:\n"
    "SELECT d, count(*) AS count FROM so_surveys GROUP BY "
    "arrayJoin(database_want_to_work_with) AS d ORDER BY count DESC LIMIT 1\n"
    "You are required to use the following format, each taking one line:\n\n"
    "Question: Question here\n"
    "SQLQuery: SQL Query to run\n"
    "SQLResult: Result of the SQLQuery\n"
    "Answer: Final answer here\n\n"
    "Only use tables listed below.\n"
    "{schema}\n\n"
    "Question: {query_str}\n"
    "SQLQuery: "