Hi,

When I try to create a view:

CREATE VIEW ULT5_ALUNOS (AL_CODIGO, AL_NOME, AL_DTALTERACAO)
AS
SELECT FIRST 5
AL_CODIGO,
AL_NOME,
AL_DTALTERACAO
FROM ALUNO
WHERE (AL_CODIGO<>0)

I got this errorÇ

Dynamic SQL Error SQL error code = -104 Token unknown - line 3, char 8 FIRST

Why the FIRST word make error?


Any help.

Thanks.

Allysson

Flickr agora em português. Você clica, todo mundo vê. Saiba mais.

[Non-text portions of this message have been removed]