テキスト比較

2 つのテキストファイルの違いを見つける

ライブエディター

未変更行を折りたたむ

折り返しなし

レイアウト

比較精度

シンタックスハイライト

Diffchecker Desktop Diffcheckerを実行する最も安全な方法。Diffchecker Desktopアプリを入手：あなたの差分はコンピューターから出ることはありません！Desktopを入手

Diff in Prompt

作成日 2 年前差分は期限切れになりません

1 削除

行
合計
削除

文字
合計
削除

この機能を引き続き使用するには、アップグレードしてください Diffchecker Pro 価格を見る

20 行

5 追加

行
合計
追加

文字
合計
追加

この機能を引き続き使用するには、アップグレードしてください Diffchecker Pro 価格を見る

24 行

"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: "

保存された差分

原文

ファイルを開く

"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: "

変更されたテキスト

ファイルを開く

"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: "