Re: how to get top 10 of query

Hey Jürgen:

versuch es mal damit

select *
from <table>
where rownum between 1 and 10

Juergen Leeb schrieb in Nachricht <38F5AF74.E149CF93_at_bmw.de>...
>i have to query only the first 10 datasets from following query:
>
>select count(FATXT),FATXT from vfufehl where SPRACHE = 'D' group by
>FATXT order by count(FATXT) desc
>
>which command do i need?
>
>thank you for your help!!!!!!
Received on Thu Apr 13 2000 - 00:00:00 CDT