I have a table full of types of differing values however I only what to return the top 100 of these distinct values. In Oracle I used to use the rownum clause but how in SQL Server 2000 is this possible? I am looking for something like:
select top 100 * from (select distinct(col1) from tab1)
Thanks in advance.