<p>You can access the NXT's H2 database from the website by going to /dbshell path. </p>

<p><strong>Example:</strong> 
Show top 100 accounts sorted by balance:</p>

<blockquote>
  <p>select *, BALANCE / 100000000 as NXT from account where latest = true
  order by balance desc limit 100</p>
</blockquote>

CC BY-SA 3.0
2016-06-30T04:06:09.300Z
2016-06-30T04:06:09.300Z
Patoshi パトシ
<p>I want to do some queries on the H2 database. How can I access this console that lets me type in commands.</p>

<nxt><database>
Access the NXT / Ardor database console?
Patoshi パトシ
# Access the NXT / Ardor database console?

(Asked by: username_0 on 2016-06-30)

I want to do some queries on the H2 database. How can I access this console that lets me type in commands.

**Tags:** nxt, database


---

## 1 answers

### Answer by username_0 on 2016-06-30. Score: 2 | Accepted answer

You can access the NXT's H2 database from the website by going to /dbshell path.

**Example:**
Show top 100 accounts sorted by balance:

> select \*, BALANCE / 100000000 as NXT from account where latest = true
> order by balance desc limit 100


---

