Re: HELP: SELECT TOP 10

Try something like:

select * from person p1
where 10 < (select count(*) from
person p2 where p2.name > p1.name)
order by p1.name;

Dieter

Harald Mika schrieb:

> Two very urgent questions:
>
> 1. Is there a way to perform a query like
> SELECT TOP 10 NAME ..... FROM PERSONS ORDER BY NAME
> which will generate only the first 10 records. There is something like
> this in MS Access. I'm sorry to mention this!
Received on Mon Apr 19 1999 - 04:19:20 CDT