Why does adding a LIMIT kill this query???

[Lurk]

SELECT DISTINCT

intranet.dbo.reqRequisitions.reqID,
intranet.dbo.reqRequisitions.Date,
intranet.dbo.reqRequisitions.OrderbyID,
intranet.dbo.reqRequisitions.FaxNumber,
intranet.dbo.reqRequisitions.orderresult,
intranet.dbo.reqRequisitions.Attention,
intranet.dbo.reqRequisitions.IsSent,
payment.dbo.Creditor.Cred_Name,
payment.dbo.Creditor.Cred_Postal_Addr,
payment.dbo.Creditor.Cred_Reference, (SELECT Orderedby FROM intranet.dbo.reqOrderedby WHERE
intranet.dbo.reqOrderedby.OrderbyID = intranet.dbo.reqRequisitions.OrderbyID) AS Orderedby

FROM

intranet.dbo.reqItems
INNER JOIN intranet.dbo.reqRequisitions ON intranet.dbo.reqRequisitions.reqID = intranet.dbo.reqItems.reqID
INNER JOIN payment.dbo.Creditor ON payment.dbo.Creditor.Cred_Id = intranet.dbo.ReqRequisitions.Cred_Id

WHERE (intranet.dbo.reqRequisitions.OrderbyID = 1) AND (intranet.dbo.reqRequisitions.IsSent = 1)

ORDER BY intranet.dbo.reqRequisitions.reqID

LIMIT 0, 20

Error message "Incorrect syntax near 'LIMIT'"

Ok this query worked fine, until I added the "LIMIT 0, 20". Taking it out makes the query work fine again... no doubt it's something very simple, but what am I missing! Why does the LIMIT kill the query? Is it in the right place?

Thanks

[Lars_Berg]

Limit is not standard SQL so why do you suppose that it should be supported in your DBMS?

[Lurk]

Thanks for the response, didn't realise it wasn't standard SQL... I know it's been asked a million times before, but how can i accomplish the same thing in MSSQL? I can't find a definitive answer... can it be done easily?

[ultraslacker]

mssql uses TOP, so

SELECT TOP 20 ....