|
Click to See Complete Forum and Search --> : How to get the first 10 rows of my result ... Laurent 03-20-2000, 11:16 AM Hello, I just wanna get the first 10 rows of my result... I tried to use the ROWCOUNT 10 , SQL command but it did'nt work ... Please Help In fact, i just wanna get a top ten ... Andrew King 03-20-2000, 02:10 PM >>I just wanna get the first 10 rows of my result...<< If you are using SQL Server 7 you can use the TOP keyword. SELECT Top 10 field1, field2 FROM table Andrew Laurent 03-21-2000, 01:38 PM Thank's for that but i'm using Sybase and i'm not sure that it works ... Is there an other way ? Andrew King a écrit dans le message <38d667eb$1@news.devx.com>... >>>I just wanna get the first 10 rows of my result...<< > >If you are using SQL Server 7 you can use the TOP keyword. > >SELECT Top 10 field1, field2 FROM table > >Andrew > > > devx.com
Copyright WebMediaBrands Inc. All Rights Reserved |
|