How to show all table rows using a nested query with SQL for Confluence

This article explains how to show all table rows using a nested query with the SQL for Confluence app.


For this purpose, the inner query must use a join such that it provides data to the outer query. The query given here is an example; thus, use relevant fields and tables to get the required details from your database.

  1. Log into your Confluence instance, and create or edit a page.
  2. Enter {sql and select the SQL Query macro, or, search for the macro name and select it. 
  3. Edit the macro, and, select Output format as Wiki and enter the following code:

The output of the above query is as follows:

Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2022 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.