LSQL Questions

Content

Hi all - I am working on an LSQL report for combining salary/assignment data to show old/new information.  I have run into a few questions that I am really hoping to get answered before posting the final report.

1. How do I do sorting?  It appears I cannot do it through the LSQL (ORDER BY ASC/DESC), and I know how to do it through the UI itself, but as you know, when you change the LSQL it wipes that formatting.  So was hoping to do it through the code.
2. Is there a way to do variables?  In SQL, I know you can create a variable at the top of the code (DECLARE