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

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


3029: <p>I want to do some queries on the H2 database. How can I access this console that lets me type in commands.</p>
 3029: <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>
