Using SQL in QlikView

[Andrew_Maynard1]

How can I just pull the first line from a table ? 

I tried "SELECT TOP 1 * FROM [TableName]" ... didn't seem to like the 1.

Even better, How would I just pull the column list ?

Even better than that, where is a user manual for SQL commands that work in QlikView

[BrunPierre]

Use the First prefix in a preceding  load.

[TableName]:

First 1

LOAD *;

SQL SELECT * FROM [TableName];