Skip to main content

View records from a SQL query

  1. Click the SQL Queries tab (SQL Queries Tab).

  2. Enter the following SQL Query:

    SELECT * from athlete

    Note

    • Data Explorer automatically adds the TOP 20 SKIP 0 clause to your SQL query to ensure it does not query all records in a table meaning the previous query is automatically changed to:

      SELECT TOP 20 SKIP 0 * from athlete

    • You can remove the values from the TOP and SKIP text boxes and Data Explorer will no longer add the TOP 20 SKIP 0 clause to your SQL query.

    • You can change the TOP to another value to retrieve a larger or smaller number of records. 

    • You can change the SKIP to another value to skip a different number of records.

    • You can also check the DISTINCT box to add the DISTINCT clause to your SQL query.

  3. Click Send request (Run Icon).

    Tip

    You can also press CTRL + ENTER on Windows and Linux or for MacOS press COMMAND + ENTER.