Query results

Last modified: 21 April 2025

In IntelliJ IDEA, you can run queries in consoles and then view and work with the result set data using the IDE interface.

Display

Usually, when you run a query, you receive results in a table format. IntelliJ IDEA displays the results in a data editor.

The data editor and viewer, or data editor, provides a user interface for working with data. In the data editor, you can sort, filter, add, edit, and remove the data as well as perform other associated tasks.

tip

For more information about data editor and how to view and work with data in it, refer to the Data editor and viewer section: View data, Compare the data of database objects, Sort data, Filter data, and so on.

By default, IntelliJ IDEA displays the data editor with query results in a separate tab of the Services tool window. You can also set the results to appear in your query console by using the in-editor results feature.

Data editor in a Result tab

For more information about query consoles and Services tool window, refer to Query consoles and Services tool window.

Result tabs in Services tool window

Run a query and view results in Services tool window

  1. In a query console, type or paste the query that you want to run.

  2. Click the Execute button Execute on the toolbar. Alternatively, press .

IntelliJ IDEA will display the query result set in the Services tool window tab.

Open a new tab for each new query

By default, IntelliJ IDEA updates the same tab with results each time you run a new query after the previous one. You can change this behavior and create a tab each time you run a new query.

  1. In the IDE settings , go to Tools | Database | Query Execution.

  2. Select the Open results in new tab checkbox and click OK.

Use custom titles for tabs with results

You can define a tab title in the comment section before the query. In the Treat text as title after field, you can reserve a combination of symbols or characters after which any text will be treated as a tab title. By default, no combination is used, so any text after -- or /* is treated as a tab title.

  1. Open settings by pressing , navigate to Tools | Database | Query Execution | Output and Results.

  2. In the Treat text as title after field, define a combination for tab titles.

    To disable this feature, open settings , navigate to Tools | Database | Query Execution | Output and Results, and clear the Create title for results from comment before query checkbox.

    For more examples of custom titles for tabs, refer to Name the result tabs at youtube.com.

    Use custom titles for tabs with results

Pin the tab with query results

If one and the same tab is used to show your query results, and you get the result that you want to keep, you can pin the tab to the tool window.

  • Right-click the tab and select Pin Tab.

    Pin the result tab

In-Editor Results in query consoles

You can also view the query results within the editor. To do that, use the In-Editor Results feature.

Editing and exploration

View two result sets in the editor

  • Click the In-Editor Results icon In-Editor Results on the toolbar to view the result sets one above the other.

    View two result sets in the editor

Edit values in the result set

  1. In the result set, click a cell value that you want to edit.

  2. Specify a new value and press .

  3. To submit changes to a database, click the Submit icon Submit on the toolbar, or press .

    For a full tutorial on submitting changes to a database, refer to the Submit changes to a database topic.

    Modify values in the result set

Compare two result sets

  1. Run queries to tables that you want to compare.

  2. In the Services tool window, click The Compare with icon Compare Data, and select the result set that you want to add to diff.

  3. If needed, change a value of the Tolerance parameter in the comparison dialog. The Tolerance parameter defines a maximum number of differences that are allowed between two result sets. For example, if you want to consider two rows as equal if their data differs in a single column, enter 1 in the Tolerance field.

    See another example of comparing two result sets in Compare data at youtube.com.

Output tab

View query log

On the Output tab in the Services tool window, you can see a log of user and internal queries.

  1. In the Database tool window (View | Tool Windows | Database) , open a query console by right-clicking a data source and navigating to New | Query Console.

    Alternatively, select a data source and press .

  2. Run a query.

  3. In the Services tool window that opens, click the Output tab.

Services tool window reference

For more information about tool window controls and tabs, refer to the the Services tool window topic.

Database services in the Services tool window

See also

Procedures

Reference