SELECT     tblOrder.*
FROM         tblOrder
WHERE     (ID < 300)
ORDER BY  ID

ID          CustomerID  OrderDate               Amount     
----------- ----------- ----------------------- ---------- 
109         255         2/7/1998                174.11     
110         1647        1/3/1998                100.56     
117         214         1/6/1998                247.76     
125         645         3/28/1998               15.31      
133         142         5/3/1999                19.29      
150         573         9/21/1998               225.34     
151         1759        4/12/1998               193.36     
169         648         5/6/1998                185.76     
174         864         12/23/1997              241.33     
178         1182        7/7/1997                39.25      
192         194         9/23/1998               154.53     
193         442         11/11/1998              79.98      
200         1644        9/23/1998               185.78     
202         896         4/2/1998                30.15      
211         634         10/24/1998              212.52     
224         978         9/27/1997               26.05      
227         1029        9/10/1997               242.83     
248         755         1/28/1999               58.27      
249         790         3/27/1999               247.26     
251         1942        8/21/1998               147.86     
252         1324        10/29/1997              159.46     
256         883         2/9/1999                15.15      
258         844         3/22/1999               60.05      
269         1058        9/3/1998                126.69     
272         506         12/3/1998               211.29     
278         473         1/27/1998               226.24     
281         1137        9/3/1998                116.94     
297         1801        3/13/1998               124.9      
299         702         4/2/1999                123.67     
No more results.
(29 row(s) returned)