sql server mseq: I am trying to run a query like the following:

set rowcount 5
Select distinct col0 from tab0 where date between 'date1'
and 'date2'
sort by count(instances of returns in select statement)

While this is a little oversimplified, I am trying to
select all distinct rows, sort them by most to least and
limit the returned rows to 5.

MySQL has a function called "limit" where I could do this
much easier, is there an easy way to accomplish this in
MSSQL?

Thanks,

See responses in .programming

--
- Anith
( Please reply to newsgroups only )