is it possible to use the count feature to display the first 20 results? Using the ID column is not an option.
SELECT TOP 20 *<BR>From Table
ok cool but now how would print the remaining? (ie everything but the top 20)
You could do something like this...<BR><BR>SELECT pub_name<BR>FROM publishers<BR>WHERE pub_id NOT IN<BR> (SELECT TOP 20 pub_id<BR> FROM publishers)<BR>