mssql question

[Guest]

How do you limit the number of rows that is fetched at the database,
in MySQL you could use the keyword 'LIMIT', is there something like that for
MSSQL?

 

[Guest]

select TOP * from ...

posted in wrong forum though

 

[Guest]

SELECT * FROM messages ORDER BY (skapad) TOP 15

results in the following errorcode:

Error -2147217900
Incorrect syntax near the keyword 'top'.

Server version : Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
if that is of any importance

- Patrick

 

[Juan T. Llibre]

Try

SELECT TOP 15 FROM messages ORDER BY (skapad)



Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================

 

[Guest]

works perfect, thanks

select TOP * from ...

posted in wrong forum though

 

[Patrick.O.Ige]

Patrick for a reference see :- http://www.transactsql.com/html/home.html
Hope that helps
Patrick