Adding LIMIT to SQL statement - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Adding LIMIT to SQL statement

Author

Topic

tkotey
Yak Posting Veteran

75 Posts

Posted - 2008-08-18 : 09:56:42

In the statment below I would like to add 'LIMIT 0,20' to it but not quite sure where to put it because when I do I get errors

SELECT DISTINCT tblInvoice.*, tblInvoiceDet.*, tblTrackingOUT.*, tblUsers.uTown
FROM ((tblInvoice INNER JOIN tblInvoiceDet ON tblInvoice.invTrackNo = tblInvoiceDet.invTrackNo) INNER JOIN tblTrackingOUT ON tblInvoice.invTrackNo = tblTrackingOUT.invTrackNo) INNER JOIN tblUsers ON tblInvoiceDet.invWorkshop = tblUsers.uTown
where tblUsers.uTown= 'Lobatse' ORDER BY tblInvoice.invTrackNo

Code with LIMIT 0,20

SELECT DISTINCT tblInvoice.*, tblInvoiceDet.*, tblTrackingOUT.*, tblUsers.uTown
FROM ((tblInvoice INNER JOIN tblInvoiceDet ON tblInvoice.invTrackNo = tblInvoiceDet.invTrackNo) INNER JOIN tblTrackingOUT ON tblInvoice.invTrackNo = tblTrackingOUT.invTrackNo) INNER JOIN tblUsers ON tblInvoiceDet.invWorkshop = tblUsers.uTown
where tblUsers.uTown= 'Lobatse' ORDER BY tblInvoice.invTrackNo LIMIT 0, 20

The error is

Syntax error (missing operator) in query expression 'tblInvoice.invTrackNo LIMIT 20'., SQL state 37000

Please help

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-18 : 09:59:06

SELECT DISTINCT TOP 20 tblInvoice.*, tblInvoiceDet.*, tblTrackingOUT.*, tblUsers.uTown
FROM ((tblInvoice INNER JOIN tblInvoiceDet ON tblInvoice.invTrackNo = tblInvoiceDet.invTrackNo) INNER JOIN tblTrackingOUT ON tblInvoice.invTrackNo = tblTrackingOUT.invTrackNo) INNER JOIN tblUsers ON tblInvoiceDet.invWorkshop = tblUsers.uTown
where tblUsers.uTown= 'Lobatse' ORDER BY tblInvoice.invTrackNo