Revision 82dd582045b2ec890b46e78d5419389be4916146 (click the page title to view the current version)

index

Changes from beginning to 82dd582045b2ec890b46e78d5419389be4916146

---
format:markdown
...
 
#Basic pSQL commands to access GOLEM data

## Last 100 discharges:
~~~~
SELECT * FROM public.shots ORDER BY shot_no DESC LIMIT 100
~~~~

## Search for the longest discharge:
~~~~
SELECT shot_no,t_plasma_duration FROM public.shots WHERE t_plasma_duration>1 ORDER BY  t_plasma_duration DESC LIMIT 100
~~~~